Forum Discussion
techsharepoint66
Oct 20, 2024Copper Contributor
Set row level permission based on column value
I have a SharePoint list like below:
| Items | First Customer | Second Customer |
| Item1 | email address removed for privacy reasons | email address removed for privacy reasons |
| Item2 | email address removed for privacy reasons | email 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.
- 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
- WarrenBelzCopper Contributor
Hi techsharepoint66 ,
https://www.youtube.com/watch?app=desktop&v=EJyZfYMi4n0 should give you a good idea on the required process.
- techsharepoint66Copper ContributorWarrenBelz Thanks, let me try this out.
- techsharepoint66Copper 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.
- WarrenBelzCopper ContributorAssuming you are using Person columns for the customers, then the process in the video (start at about the 17 minute mark) should be viable.