Forum Discussion
NikR1
Jun 25, 2024Copper Contributor
Sharepoint Excel hierarchical access
Hi All, I am new to Sharepoint Excel. I need to know if custom access can be created in Sharepoint Excel. I want to create 2 sets of user groups. Senior and Junior. Both will have edit access fo...
michalkornet
Jun 25, 2024Steel Contributor
Hi NikR1, what about creating a Power Automate flow connected to the target Document Library?
The flow would be as follows:
- When a file is edited:
- Check who the editor is.
- If the editor is in the Senior group,
- then assign unique permissions for the file.
Check some guidelines on how to set permissions on SharePoint list items and files.
-> https://steveknutson.blog/2021/12/10/setting-sharepoint-permissions-with-power-automate/
I hope that it will help in your case.