cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
abhi2
New Member

Filter gallery only direct reportees of loged in manager

i'm trying to filter user details who comes under manager who is logged in ... any idea.?

1 ACCEPTED SOLUTION

Accepted Solutions
v-siky-msft
Community Support
Community Support

Hi @abhi2 ,

 

You can use Office365Users.DirectReportsV2(User().Email).value.mail code to get all direct report Emails of login users, then use Filter function to filter the record that that the email column value belongs to the direct report.

Please try this:

Filter(Table, EmailColumn in Office365Users.DirectReportsV2(User().Email).value.mail)

 

Hope this helps.

Sik

View solution in original post

2 REPLIES 2
v-siky-msft
Community Support
Community Support

Hi @abhi2 ,

 

You can use Office365Users.DirectReportsV2(User().Email).value.mail code to get all direct report Emails of login users, then use Filter function to filter the record that that the email column value belongs to the direct report.

Please try this:

Filter(Table, EmailColumn in Office365Users.DirectReportsV2(User().Email).value.mail)

 

Hope this helps.

Sik

hi @v-siky-msft , how do we handle delegation in this case?

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.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

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 (3,042)