Forum Discussion
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 for the file but if a cell is edited by Senior user then Junior user cannot edit that cell. This is a primary requirement.
I have been going through tutorials and documentation regarding accesses. There are standard ways like read / edit accesses. I could not find anything specific to this scenario. Usually if user has edit access then he can edit anything in sheet. I wanted to know can that be limited ?
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.
