Forum Discussion
Multilevel RLS with userprincipalname
Hi All, Can anyone help with pointing me in the right direction towards extending RLS beyond what I'm allowed to view? Scenario: So, I have the following structure: Now I was able ...
Thanks for your quick response avanderschilden
This is exactly where I got stuck: Emp 1 in your use can see Emps 2 & 3.
But because Emp 4 reports to Emp 2 who in turn reports to Emp 1, I want Emp 1 to be able to see figures for Emp 4 as well. Kind of like a waterfall RLS from the top node to the most bottom node in that chain for Emp 1
Regards,
Bare
So why dont you just add a row with;
Emp1 | Emp4
In that case you have what you need right?
You just have to store your table with parents and childs different, without level. Just 2 columns with a parents and child.
Emp1 | Emp4
In that case you have what you need right?
You just have to store your table with parents and childs different, without level. Just 2 columns with a parents and child.
avanderschilden It's a good idea worth trying. I was avoiding any manual maintenance (the employee file comes from a separate system) that I didn't think of this. I'll simply carve out a 2 column solution with Power Query and let you know how it goes.
Many thanks