cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Yoursnani
Post Patron
Post Patron

User based screen in SharePoint integration with power apps

Hi 

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 

9 REPLIES 9
CNT
Super User
Super User

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

@CNT 

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?

@CNT  

 

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

@Yoursnani 

Please try the following,

Switch(User().Email,
   "person1@email.com", Navigate(ApprovalScreen),
   "person2@email.com", Navigate(ApprovalScreen),
   Navigate(EditScreen)
)

 

CNT
Super User
Super User

@Yoursnani Did you get it to work?

@CNT 

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 

Hi,

 

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!

Regards,

Bipin Kumar

Follow my Blog: https://xrmdynamicscrm.wordpress.com/

@bipinshan 

 

Can you Please Explain . i am new to power apps

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

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

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

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 (6,100)