Permission & Access Issues

How to Automate Row-Level SharePoint Permissions with Power Automate

Maira Mehtab Sep 21, 2026 868 views

Question details

The user needs to automatically assign item-level (row-level) 'Contribute' access to specific individuals based on their IDs and email addresses when a new item is added to a SharePoint list.

Product: Microsoft SharePoint and Power Automate
Device & OS: not provided
Scenario: Setting up an automated workflow to manage user-specific row-level access in a shared SharePoint list upon item creation.
Observed behavior: The user is looking for the correct setup and methodology to apply item-level permissions automatically without granting users access to rows they shouldn't see.

Before you start

Ensure you have Site Owner or Full Control permissions in your SharePoint site to manage item-level permissions, and verify your access to Power Automate to create new flows.

Solution 1Recommended

Seek Expert Guidance in the Microsoft Power Platform Community

Because automating item-level SharePoint permissions involves complex Power Automate configurations, the best approach is to consult the dedicated Microsoft Power Platform Community.

Setting up row-level permissions requires breaking permission inheritance and assigning new roles dynamically. Due to the intricacies of Power Automate expressions and SharePoint REST APIs often used in these scenarios, official community experts can provide tailored, step-by-step guidance.

Visit the Power Platform Community

Navigate to the official Microsoft Power Platform Community forum using the provided URL: https://community.powerplatform.com/forums/thread/?groupid=46ce02a3-e1a7-4176-81fc-d93a4001d287

Sign In to Your Account

Post Your Scenario Details

Create a new thread or reply to a relevant discussion, detailing your SharePoint list structure (unique IDs and email addresses) and your requirement to assign 'Contribute' access dynamically.

Community Support: The Power Platform Community is highly active, and Microsoft MVPs often share pre-built flow templates for SharePoint permission management.

Solution 2

Use Standard Power Automate Actions for Item Permissions

Understand the foundational Power Automate steps required to adjust row-level permissions for a SharePoint list.

Free Microsoft Office alternative

Need a Lightweight Office Alternative? Try WPS Office

While advanced automation like SharePoint and Power Automate workflows requires the Microsoft ecosystem, WPS Office provides a completely free, fast, and highly compatible alternative for your everyday document creation, spreadsheet data management, and presentation needs.

1. Download the Installer: Visit the official WPS Office website and click the 'Free Download' button.
2. Install WPS Office: Run the downloaded installation file and follow the quick on-screen instructions to set up the software.
3. Start Creating: Open WPS Office to instantly view, edit, and save your Microsoft Office-formatted documents, spreadsheets, and presentations.

Seamless format compatibility with Microsoft Word, Excel, and PowerPoint (.docx, .xlsx, .pptx)Free and lightweight design that runs smoothly on any hardwareBuilt-in advanced PDF editing and formatting toolsPowerful spreadsheet features tailored for robust data analysis without the high cost

microsoft office alternative - wps office

Frequently Asked Questions

Can I set item-level permissions natively in SharePoint without Power Automate?

Yes, you can manually stop inheriting permissions and assign unique permissions per item by navigating to the specific list item, clicking 'Manage Access', and adjusting the settings. However, doing this automatically upon item creation requires Power Automate.

Does automating SharePoint permissions require a premium Power Automate license?

No, the standard 'Stop sharing an item or file' and 'Grant access to an item or file' actions are part of the standard SharePoint connector in Power Automate and do not require a premium license.

Why does my flow fail when trying to stop sharing an item?

This usually happens if the account running the Power Automate flow does not have Full Control or Site Owner permissions on the target SharePoint site. You must have adequate privileges to alter list item permissions.

Document & File Issues