Forum Discussion
jimmy7377
6 years agoFrequent Visitor
Row Level security Filter over 4 tables
Hello friends and follow Power Bioneers Im a relative Noob compared to alot of you so please go easy on me. I am having some (I play done the some) issues with getting my RLS to work see belo...
mwegener
6 years agoMost Valuable Professional
Hi jimmy7377 ,
try this.
[Role] IN SELECTCOLUMNS( FILTER(Users, Users[Email] = USERPRINCIPALNAME()), "Role", Users[User_Role])- jimmy73776 years agoFrequent Visitor
mwegener Thank you kindly for your help on this.
It is telling me Column 'Role' Cannot be found or may not be used in this expression Refering to the first [Role] Move it to Committee Name it then accepted it but when applied would not show any Committee _Name and would not filter Area_role or Role.