RLS - Multiple Filters using USERPRINCIPALNAME

[cristianml]

Hi,

I need to use 2 RLS  to filter different categories based on ID .

When I use one categoy it works fine, in this case Access_Market_Unit.   But when I add another USERPRINCIPALNAME in (Access_ client)  It doesn´t work. after I publish this it shows no data cause of this second RLS.

How can I solve this ?

Thanks.

[Smalfly · Accepted solution]

Hi,

to be able to use RLS, you need a relationship between 'Access_client' and 'CCMS billings append' that works in both directions:

Once you have set the filter direction to 'Both', make sure to tick the "Apply security filter in both directions" checkbox.