Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Screen Permissions and Access

I have created a basic 3 screen app made up of a browse, detail and edit screen.


I would like to try and achieve the following:


  • Make all three screens only available to certain admin users in AD
  • Make the "New" element of the edit screen available to all my users in AD

Is there a formula I can put in the "visible" control of the browse and detail screens to achieve this or is there another way?


Any help much appreciated.






Good suggestion Shane, thank you for sharing that! I've been following your videos on Youtube even 🙂


Can we also use DL or so instead of individual email IDs? I checked, User can't do that, is there any function or so to work with the distribution lists.


As this will help, to add remove from the DL and we don't need to tweak the app in future if people leave organization.


Please suggest if anything!




@Jdemke  I see, we should use || OR to use, else the the item will be visible only if all the users are available. 



In this case how can PowerApps can knows who are the person that have that emails? I mean, you have to create a collection with specific emails and usernames to function "User()" works? or you only have to share your app and PowerApps take the people´s email.

Continued Contributor
Continued Contributor

Not sure if I understood your question, but if you're trying to address the challenging of having multiple users and deal with changes to the list of users without having to update the app, you could create a small sharepoint list with the email addresses of the users who need advanced permissions. You could then to a lookup to that list, filtering on the email address of the current user. If the row count of that filtered table is 1, then there's a match, otherwise the user isn't on the list. Pseudocode for this would be something like:








In this case I have an app where I need that only one person can see the bottoms on a screen and other people not. When I share the app with the manager and other user all of them can see all bottoms.


I´ll show you my code:


So, I don´t know if I need a shareporint list to PowerApps catch the emails, in this case: and


Thank you so much.


Have a nice day 🙂

Helpful resources


Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

New Power Super Users


We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Solution Authors
Top Kudoed Authors
Users online (18,142)