Row Level Security with multi roles

[tracytran91]

Hi friend, 

Could anyone please kindly help me to set RLS for this user?

He is in charge of Thailand region which allows him able to see all products sold in ThaiLand. Meantime, He has additional role in charge of Product Candy which allows him to see performance of candy at all region. 

Any help is high appreciated. 

[v-xiaotang · Accepted solution]

Hi @tracytran91 

try this 

result

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[tracytran91]

@v-xiaotang Thank for your solution. 

I would like to ask whether there is a dynamic way to make it work? 

[amitchandak]

@tracytran91 , You can not use all. This what I have done. I create a table like this

Product	Product All
A	A
B	B
C	C
D	D
A	All
B	All
C	All
D	All

I joined it product column and merged in power query(on product All)  and removed all and got the products

The same need to be done for the region