
Announcements
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.
Is it possible to automate this process using Power Automate?
Could anyone provide step-by-step guidance on how to set up this automation?
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!