Insert a condition on the managing role RLS

[menphis21]

Hi,

i have a table with all the data about the hours that each employee reports each month.

I have a hierarchy with user, his counselour, team leader etc

But i want that the counselor can see his team and also himself in the data so its means that i need to write in the managing role something like 

[Counselor Email]= Userprincipalname() or [User Email]= Userprincipalname()

How can i do it ?

Thank you 🙂

[Padycosmos]

I hope this video might help:

https://www.youtube.com/watch?v=0OPcZeLHbfY&list=PLApPcvU5-R24K3mbxORV7T3ckVLfDjmHF&index=24

[amitchandak]

@menphis21 , refer if this can help

https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi