Filter gallery only direct reportees of loged in manager

[abhi2]

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

[v-siky-msft · Accepted solution]

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

[nmn_lamba]

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