Showing results for 
Search instead for 
Did you mean: 
Post Patron
Post Patron

User based screen in SharePoint integration with power apps


Am customizing SharePoint list form, and I have 4 forms in it . one is new ,second is view , third is edit request , and fourth is Approve form.


My scenario is when my manager open is edit mode . then only open approve form. Rest anyone click on edit , then edit request form need to open . 


Please help me 

Thank you 

Super User
Super User

@Yoursnani How do you distinguish between a Manager and a Normal User? Where is this information stored? 


Can we defined with user().Email like that ???


@Yoursnani User().Email will give the email of the currently logged in user. But you will need to compare this with the email of the user to see if they are a Manager or a Normal user. Where do you have this information stored?



I want to give only two people and I have their mail I'd's. Those two people only can access approve form. Can we do that


Please try the following,

   "", Navigate(ApprovalScreen),
   "", Navigate(ApprovalScreen),


Super User
Super User

@Yoursnani Did you get it to work?


its worked well but . can we do same with group ?, if i have one SharePoint Group and i want that people only can load approvalScreen, Rest are should open Edit Screen ,

if Yes . please give me codes how to do with Groups 

Thank you 



You can load your sharepoint group records to a collection in your powerapps.


ClearCollect(sharepointGroups, 'Group name');


Once you have the data loaded in your collection you can easily do lookup/filter on collection to see if logged in user is present in group. based on the result you can navigate user to respective screen.


Please mark my answer verified if this is helpful!


Bipin Kumar

Follow my Blog:



Can you Please Explain . i am new to power apps

Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

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