Hi @venky232 :
You could use this formula to get the current user's manager:
Filter(
TheSPList,
User().Email=emailcolumn
).managercolumn
You could user this formula to get the current user's manager's Direct Reports:
Filter(
TheSPList,
managercolumn in Filter(TheSPList,User().Email=emailcolumn).managercolumn
).emailcolumn
So the Filter formula should be:
Filter(
TheSPList,
emailcolumn = Filter(TheSPList,User().Email=emailcolumn).managercolumn ||
emailcolumn in Filter(
TheSPList,
managercolumn in Filter(TheSPList,User().Email=emailcolumn).managercolumn
).emailcolumn
)
Additionally, if you already have an org structure relationship in your tenant.
You could use this formula to get the current user's manager:
Office365Users.ManagerV2(User().Email).mail
You could user this formula to get the current user's manager's Direct Reports:
Office365Users.DirectReportsV2(Office365Users.ManagerV2(User().Email).mail).value.mail
So the Filter formula should be:
Filter(
TheSPList,
emailcolumn = Office365Users.ManagerV2(User().Email).mail ||
emailcolumn in Office365Users.DirectReportsV2(Office365Users.ManagerV2(User().Email).mail).value.mail
)
Best Regards,
Bof
