Forum Discussion
SharePoint Online : Permission to list based on user
How can we setup list permission based on following scenario: -
- Administrator and SP Group A should be able to see records of all users -
- SP Group B should be able to see records where department = "ABC" -
- Other users should be able to see only records where Manager = [ME]
We are using SharePoint online.
1 Reply
- You cannot accomplish this out of the box. You can do security by obscurity, but if it's sensitive data you won't be able to accomplish this. You can customize some powerapp forms, but others can still see the list data no matter how you do it.
The best you can do is have admin and group A see all records and other users see their own records / submissions but you can't filter it based off another column. If you need something like this you are looking at a custom SharePoint solution, but even with SPFX / Modern UI the data cannot be secured at that level from a SharePoint list.
