Forum Discussion
Automating Permissions
Question Title:
Automating Permissions for New Document Libraries in a SharePoint Hub Site Based on a Templated CSV
Description:
I have a SharePoint hub site for all our projects. For each new project, I need to create a new document library within this hub site.
The challenge I'm facing is that each document library needs a specific, templatized folder and permission structure for different departments.
My goal is to find an automated solution that, whenever a new project library through template is created, it automatically applies the correct folder structure and permission levels as defined in my template.
Are there any other out-of-the-box SharePoint features or Power Automate that can accomplish this?
1 Reply
There isn’t an out-of-the-box (OOTB) SharePoint feature that fully supports this level of automation. To address this, I implemented the following custom solution:
- Project Request List: I created a SharePoint list where users can request a new document library for a project.
- Power Automate Trigger: When a new item is added to the list, it triggers a Power Automate flow.
- Azure Automation with PnP PowerShell: The flow initiates an Azure Automation job that runs a PnP PowerShell script.
- Library Creation & Permissions: The script creates the document library, applies the predefined folder structure, and sets permissions based on predefined rules.
- Notification: Once the process completes, a success or failure email is sent to the user who submitted the request.
