Forum Discussion

NikR1's avatar
NikR1
Copper Contributor
Jun 25, 2024

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...
files
Microsoft365
SharePoint Online
michalkornet's avatar
michalkornet
Steel Contributor
Jun 25, 2024

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://learn.microsoft.com/en-us/sharepoint/dev/business-apps/power-automate/guidance/manage-list-item-file-permissions

-> https://steveknutson.blog/2021/12/10/setting-sharepoint-permissions-with-power-automate/

 

I hope that it will help in your case.