web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Automating Row-Level A...
Power Automate
Unanswered

Automating Row-Level Access Control in SharePoint List Using Power Automate

(0) ShareShare
ReportReport
Posted on by

Hello Microsoft Community,

 

 

I have a requirement involving a SharePoint List where my customer maintains a record of persons, each with a unique ID and email address. The goal is to ensure that for each row in the list, the corresponding ID should have access to that specific row, while access to other rows is restricted.

 

I have set up the list and configured permissions so that when an ID is entered, the respective user can contribute to that row. This implementation works as expected.

 

I want to scale this solution. Specifically, I need to automate the process of granting "Contribute" access to a user based on the ID entered in the list. Ideally, when a new ID is uploaded, the system should automatically assign the appropriate access permissions without manual intervention.

 

 

  1. Is it possible to automate this process using Power Automate?

  2. Could anyone provide step-by-step guidance on how to set up this automation?

  3. Are there any best practices for managing item-level permissions in SharePoint lists?

Summary: Basically, I want when I add new item in row for ID column when ID filled in that column directly access provided to that ID so that he can edit those other columns at the same time this ID should not have access to other rows. I have 10K ID to be filled so need power automate for scaling.

 

Thank you for your help!

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard