web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / granting user access t...
Power Apps
Unanswered

granting user access to a specific power app

(0) ShareShare
ReportReport
Posted on by 90

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?

Categories:
  • WarrenBelz Profile Picture
    156,921 Most Valuable Professional on at

    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

  • winston_smyth Profile Picture
    90 on at

    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?

  • WarrenBelz Profile Picture
    156,921 Most Valuable Professional on at

    @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.

     

    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

  • winston_smyth Profile Picture
    90 on at

    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.

  • WarrenBelz Profile Picture
    156,921 Most Valuable Professional on at

    @winston_smyth ,

    Have you tested this ? I am not an SQL user.

  • winston_smyth Profile Picture
    90 on at

    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.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 234 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 207 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 169

Last 30 days Overall leaderboard