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 accounts under one particular role.

 

Eg: I have Created New role like Test under this role I wanted to keep two accounts A and B, if person selecting Test role he wanted to see A and B key accounts only.

 

Could you please help me out on this.

 

Need Help

1 Reply

  • 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.