Forum Discussion

Balaraju's avatar
Balaraju
Helper III
3 years ago
Solved

How to setup RLS for two different key accounts under one role

Hi All,   I have one scenario I need to setup RLS for One role I wanted to see two key accounts under that particular role. Below screenshot showing some data. Just I wanted to create two key accou...
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    3 years ago

    Hi Balaraju 

    Thanks for reaching out to us.

    please try this

     

    (USERPRINCIPALNAME()= "test" && [Key account] in {"A","B"}) || (USERPRINCIPALNAME()<>"test" && [Key account] = USERPRINCIPALNAME())

    sample data

    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.

v-xiaotang's avatar
v-xiaotang
Community Support
3 years ago

Hi Balaraju 

Thanks for reaching out to us.

please try this

 

(USERPRINCIPALNAME()= "test" && [Key account] in {"A","B"}) || (USERPRINCIPALNAME()<>"test" && [Key account] = USERPRINCIPALNAME())

sample data

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.