So I am making a power app. I don't think the main function of the app is relevant so I won't explain that. But my company is large and heavily integrated into Microsoft. So we have AAD/ EntraID(that I can't access) SharePoint. M365 etc. No dataverse.
So I figure the best data storage for my app is going to be SharePoint lists.
In general everyone at the company has access to SharePoint. But I don't really want anyone to have to interact with SharePoint to use this app. I would also love to not have to manage the requests my self.
So right now. I have SharePoint setup to allow auto approval for a low level permission. That allows read/write to certain lists. This is what 90% of user will need.
But, the user still needs to request access through a link or I have to add them myself. Then before they use the app they have to go to the SharePoint once to "authorize".
When I tried this without them going to SharePoint first I get errors that they can't access the data.
So my question is. Is there a way to automate this through the app? I would love to just send them the app and everything be handled that way instead of the user needing to do multiple different seemingly unrelated things in order to use the app.
I am open to any solutions not just the flow I described. I am just newer to power Apps and I don't know all the options available.