Announcements
I am trying to grant a user access to just two speific power apps. They should have no access to the other power apps.I cannt see how this is accomplished in the admin portal and think i am misunderstanding the security and access model.
Could someone explain how it is possible to grant a user with a license access to just one or two specific apps?
Hi @winston_smyth ,
You simply need to share the apps with them (and do not share any others). Naturally any associated data sources need to be shared with the user.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps
thank you, i had assumed there would be a method of granting permissions similar to granting azure permissions, and not simply sharing an app.
Regarding granting access to underlying tables, can i just create a webrole, add these users and grant the webrole access to the tables?
@winston_smyth
You did not say what your data source was, but whatever the case, their Office365 login to Power Apps also needs to be valid access to the data source.
the data source is an external/linked table in the dataverse, the source of which is a sql server database.The connector uses sql auth, and takes a username and password so the app users wont require access to the sql database.
@winston_smyth ,
Have you tested this ? I am not an SQL user.
the issue is definately at the power platform security level.I have tested with a user that has no sql database permissions.If this user is assigned Environment Admin privileges they can use the app and see/manipulate data in the virtual table via the app.If i remove the user from the admin role, they lose this ability.This indicates that virtual tables require additional permissions within the environment and/or dataverse.I cannot find documentation on what these permissions are however.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 234 Super User 2026 Season 2
WarrenBelz 207 Most Valuable Professional
Mohsin Ali 169