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 pro...
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.