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. 

Frequent Visitor



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

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,221)