in galley if user is not a manager list only his records and if manager list all record of users under him and his records in the galley

(0) Share

Report

Posted on by GTurkistane

114

i have the records stored in a SharePoint list called LeaveRequest :

and users stored in a office364 group.

what i want is that myapp gets the sign in user email and check if he is a normal user or a manager in office group, then based on that if he is a manager the gallery will display all records in the SharePoint list that he assigned in as manager and display his records too if he requested a leave but if he is normal user then only display the users records alone

Categories:

Building Power Apps

All responses (8)

Answers (0)

Sort by

Shaheer Ahmad 2,194 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Get User's Role (Manager or Normal User):

Office365Users.UserProfile(User().Email)

Filter the Gallery Based on User's Role:

If( Office365Users.UserProfile(User().Email), Filter(LeaveRequest, ManagerEmailColumn = User().Email || RequesterEmailColumn = User().Email), Filter(LeaveRequest, RequesterEmailColumn = User().Email) )

Replace {Office365GroupName}, ManagerEmailColumn, and RequesterEmailColumn with the actual values from your setup.
GTurkistane 114 on at

Like
a
(0)

Report
Copy link

Link copied!

the code is giving me:
name isnt valid "isMemberOf" isnt recognized
Shaheer Ahmad 2,194 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

I've updated the code above try if this works....
Lemme open power apps and i'll try to figure out how to check if a user is in a Office group
GTurkistane 114 on at

Like
a
(0)

Report
Copy link

Link copied!

nope it did not, it is telling me that "if" has invalid arguments
Shaheer Ahmad 2,194 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

where are you writing this code?
Shaheer Ahmad 2,194 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Replace ManagerEmailColumn, and RequesterEmailColumn with the actual column names from your dataset.
GTurkistane 114 on at

Like
a
(0)

Report
Copy link

Link copied!

in the item section of a gallery
GTurkistane 114 on at

Like
a
(0)

Report
Copy link

Link copied!

do you mean the person column? i do not have an email column in sharepoint, all emails are managed in the tenant environment