Hi, I can create a user in our domain who has a trial license for PowerApps but no license for Office365.
They can run an app that has a connection to an Azure SQL DB.
They can view our SharePoint Online sites and document libraries etc.
However, when I add a connection to SharePoint in PowerApps, they are not allowed to go further since the Allow button is disabled (see below).
Is this by design?
Does it mean that a user needs an Office365 license in order to use a PowerApp that connects to SharePoint Online?
Many thanks for any insight.
PS I read this illuminating exchange by @audrieg and @sarafankit but it did not help with my particular issue.
Solved! Go to Solution.
Thanks for the information, are you or were you using the Office365Users connection as well in the app?
Can you please:
Let's see if this gets you unblocked, I am still trying to figure out what is happening, it doesn't seem like a licensing issue per se.
Hi @sarafankit
Apologies, my mistake. Indeed the issue was not with the SharePoint connection or with the Office365Users connection, but with the SQL Server connection. I had forgotten that this type of connection is not shared automatically when the app is shared, but needs to be shared as well.
Many thanks for the quick and useful help!
Can you please provide us the session id where you are seeing this issue? If you use PowerApps mobile player or studio for windows, you can get that via Account > Debug > Session Id
If you cannot find the session id, please provide the email-id of the user you have created.
Thanks for the information, are you or were you using the Office365Users connection as well in the app?
Can you please:
Let's see if this gets you unblocked, I am still trying to figure out what is happening, it doesn't seem like a licensing issue per se.
Hi @sarafankit
Apologies, my mistake. Indeed the issue was not with the SharePoint connection or with the Office365Users connection, but with the SQL Server connection. I had forgotten that this type of connection is not shared automatically when the app is shared, but needs to be shared as well.
Many thanks for the quick and useful help!
User | Count |
---|---|
126 | |
87 | |
85 | |
75 | |
69 |
User | Count |
---|---|
215 | |
180 | |
139 | |
103 | |
83 |