Forum Discussion

leniorcortivo's avatar
leniorcortivo
Advocate I
4 years ago
Solved

Hide Specific Values in a Table

Hello,   I received an challenge to share a performance report to our team but we would like to the user that is opening the report be able to see only his name at the Table, but would be allowed t...
  • v-xiaotang's avatar
    4 years ago

    Hi leniorcortivo 

    Some ideas.

    First of all, RLS cannot achieve this, because in your data, the second row of records belongs to [email protected], the third row belongs to [email protected], but for row-level security(rls), filters restrict data at the row level. 

    So if you want to use RLS to "hide" other users' names, you need change your datasource like this, then you can use USERPRINCIPALNAME() funcion 

    this is the first way, or you can use conditional formatting to hide. By this way, you can make other users' names white so they don't appear visually. But in fact other names still exist.

     

    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.