Forum Discussion
List access - Permissions
- Apr 15, 2024
Hello DanFountain
i recommend to set permissions with a Power Automate Flow: https://learn.microsoft.com/en-us/sharepoint/dev/business-apps/power-automate/guidance/manage-list-item-file-permissions?WT.mc_id=DX-MVP-5004845
Give everyone contribute access to the list, after creating a item, stop the permission inheritance and set they own permission on every item. Please attention with the limits and boundaries: https://learn.microsoft.com/en-us/office365/servicedescriptions/sharepoint-online-service-description/sharepoint-online-limits?WT.mc_id=DX-MVP-5004845#unique-security-scopes-per-list-or-library
Best, Dave
Hello DanFountain
i recommend to set permissions with a Power Automate Flow: https://learn.microsoft.com/en-us/sharepoint/dev/business-apps/power-automate/guidance/manage-list-item-file-permissions?WT.mc_id=DX-MVP-5004845
Give everyone contribute access to the list, after creating a item, stop the permission inheritance and set they own permission on every item. Please attention with the limits and boundaries: https://learn.microsoft.com/en-us/office365/servicedescriptions/sharepoint-online-service-description/sharepoint-online-limits?WT.mc_id=DX-MVP-5004845#unique-security-scopes-per-list-or-library
Best, Dave
- Matiss_VilksJul 01, 2024Copper Contributor
Hi, David.
We have been using this method for some time now, however it is not bulletproof and thus you have to be careful when granting access to new users to the list.
If "Manage access" is used directly from the list, and edit permission is given to the user, he will be given recursive permission to view and edit all list items created before. Any new list items will be restricted by Power automate flow.
Solution is to go through all the list items' permissions every time user is added but that creates issues if owners are not present at the company anymore and just consumes resource and creates extra flows to worry about.
However, we have been successful by adding new users to the list using Classic list settings>Permissions for this list, adding permissions this way did not give recursive permission to previously created list items.