Forum Discussion
Solved
Row Level Security with multi roles
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 additiona...
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 , 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