Problem Statment

  • Replace SharePoint Item level permissions using Power Automate 

Solution

  • We can achieve this by running Automated cloud flow and the steps are as follows.

Step 1

  • Create SharePoint list (ex-Student Details) as shown below screensho

Step 2

  • Open Power Automate and create automated cloud flow (Replace Permission) with following configuration (see screenshot below)
  • Trigger – When Item is Created or Modified
  • Action 1. Stop Sharing an Item or File – This step will stop the sharing particular item to the users

Step 3

  • Now add the last action “Grant access to an item or folder” and configure the action as follows (See screenshot shown below)
  • ID – Provide the ID of newly created or current edited item
  • Recipients – Name of the user to whom you want to provide access (As of now I am giving access to the person (Created by) who creates the item)
  • Roles – Select the View/Edit option from the given dropdown.
  • Notify Recipients – You can select Yes or No

  • Now check by adding new item in the List or library the permission will be applied as per configured in flow.

And Next Flow Run Successfully

For any Help or Queries Contact us on info@crmonce.com or +918096556344