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

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

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