Share via

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

Anonymous
2024-11-22T14:43:49+00:00

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?

Thank you for your help!

Microsoft 365 and Office | SharePoint | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-11-22T15:22:25+00:00

    Dear AMAN SALIM SHAIKH SHAIKH,

    Good day to you!

    I hope you are doing well. Thanks for reaching out to our Microsoft Community Forum. We will be happy to help you.

    This forum is mainly focus on Microsoft 365 and Office in-built features.

    Based on your description, I can tell your concern is related to Power Automate. Unfortunately, the Power Automate related question are not supported in this community.

    However I believe it may be achievable through the utilization of Power Automate, I sincerely recommend you post your concern to the specific channel Microsoft Power Platform Community. Members and engineers over there are proficient in the knowledge of Power Automate issues. We are sure that our experts from that team can address your query effectively and accurately.

    I do apologize for any inconvenience.

    Thank you for your understanding. Your patience and cooperation are greatly appreciated.

    Best Regards,

    Nahid Sultan

    Was this answer helpful?

    0 comments