Forum Discussion

jimmy7377's avatar
jimmy7377
Frequent Visitor
6 years ago
Solved

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...
Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    Hi jimmy7377 ,

     

    try this.

    [Role] IN SELECTCOLUMNS( FILTER(Users, Users[Email] = USERPRINCIPALNAME()), "Role", Users[User_Role])
jimmy7377's avatar
jimmy7377
Frequent Visitor
6 years ago

See complete plonker.

 

thakn you so much, that seems to be working on testing im going to test further.

 

thankyou a thousand times

Jimmy

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hey jimmy7377, you're welcome. ðŸ˜‰