I have a PowerApp that is used by many colleagues and works fine, except for one single person who is unable to access it.
He is stuck at the screen that asks to grant permissions ("your app needs permission to use : SQLserver") and the Allow button is greyed out (screenshot below).
He already tried to:
Any advice? Is there any internal support I can reach out to?
If your app uses an on-premise SQL Server database, a likely cause of this problem is that the user doesn't hasn't been assigned a P1/P2 license.
To diagnose whether or not this is a licensing problem, I would click the cog icon > Plans menu item for a user that is able to access the database. Next, ask the user that experiences the problem to do the same. Is there any difference between the plans that are assigned to the user?
I checked the plans. Both me, another user who can access the app and the user who cannot are seeing the same plans that also appear in your screenshot:
- PowerApps for Office365
- PowerApps Trial
The app connects to a database that is hosted on Azure. The app sharing is set to a group, and the Data Permissions shows: SQL Server - Implicitly Shared.
I also made sure that the user is into that group/distribution list.
Any other advice?
Hi @a-anscac ,
I suggest you check your SQL whether allow users to write/read.
What's more, not only you need to share the app, but also they need to recreate connection with SQL.
You could check here to see whether your connection is share successfully:
When I open the connections page it gets stuck on loading and the console is full of errors. I tried in Edge and Chrome.
Do you know if tech support can check this kind of things for me?
Join us next Wednesday for our Demo Extravaganza, October 16, 2019 8am PDT.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
Continue your learning in our online communities.
Features releasing from October 2019 through March 2020
Coming to a city near you
Fill out a quick form to claim your user group badge now!
Connect, share, and learn with your peers year-round
Register by September 5 to save $200