USERPRINCIPLENAME for direct and indirect employees
I have a table Users: manager_email employee_name Path [email protected] Employee 1 [email protected]|[email protected]|[email protected] [email protected] Employee 2 [email protected]|[email protected]|[email protected] [email protected] Employee 3 [email protected]|[email protected]|[email protected] [email protected] Employee 4 [email protected]|[email protected]|[email protected]|[email protected] [email protected] Employee 5 [email protected]|[email protected]|[email protected]|[email protected] There is RLS on the table Users: CONTAINSSTRING ( [Path], USERPRINCIPALNAME()). I want to have 2 pages on the report: 1) All employees - this is working fine based on the RLS. 2) Direct employees - I want to apply page filter where USERPRINCIPALNAME() = Users[manager_email]. How I could achive that?