Forum Discussion

techsharepoint66's avatar
techsharepoint66
Copper Contributor
Oct 20, 2024
Solved

Set row level permission based on column value

I have a SharePoint list like below:

 

ItemsFirst CustomerSecond Customer
Item1email address removed for privacy reasonsemail address removed for privacy reasons
Item2email address removed for privacy reasonsemail address removed for privacy reasons

 

I want to set row level permissions so that Item1 can only be viewed and modified by customer1 and customer2 and Item2 can only be viewed and modified by customer3 and customer4

 

Please suggest how to achieve this.

 

  • WarrenBelz's avatar
    WarrenBelz
    Oct 20, 2024
    Assuming you are using Person columns for the customers, then the process in the video (start at about the 17 minute mark) should be viable.

4 Replies

    • techsharepoint66's avatar
      techsharepoint66
      Copper Contributor

      WarrenBelz  Thanks for the response. In my case the items are not created by the users. They are created by the admin. However I want to limit the row permissions based on the column values in First Customer and Second Customer columns. 

      • WarrenBelz's avatar
        WarrenBelz
        Copper Contributor
        Assuming you are using Person columns for the customers, then the process in the video (start at about the 17 minute mark) should be viable.

Resources