I have created a Power Apps which uses the Excel connector to connect to an Excel sheet on SharePoint. Data is pulled via a flow. In the flow I have specified "Use this connection <email>" as opposed to "provide by run-only user". Reason being I have access to the SharePoint site that hosts the Excel file whereas the users don't have access.
The user gets the following error. Firstly am I right to say this is simply a license question as opposed to an access control issue?
If so does the user need to get licensed to use the Power Apps app or does this message appear because the app uses the Excel connector?
What license(s) do we need for this?
This is purely the fact they do not have a license. SharePoint is not premium but be careful as who knows if this can change, and what you are doing is MultiPlexing. I do not see an issue with it today, due to it being SharePoint, but... if its ever dataverse and Power bi and some other scenarios it would be against policy.
Someone in IT needs to buy them or grant them a License. The app is configured to support Per App plans which means they could be given a license for say.. 1 app in total and it would automatically work for this app(assuming there are enough licenses for that).
Cheers
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.