Restrict Permissions in a List to row where email matches

Question

Hi all&nbsp;This is an step on from item level permissions I think.&nbsp;&nbsp;I have a MS list that I want to share with multiple external users. They can view all rows but I only want them to edit the ones where the email field contains their email (there may be 1 or more emails in each row).&nbsp;Any ideas on how to enable this, or if its even possible.&nbsp;&nbsp;Thanks&nbsp;Kev

ganeshsanap · Accepted Answer

Kev2023&nbsp;You can achieve this using Power automate flow. Follow the steps:Create a Power automate flow which will run on item creation/update - use site owner/admin account for creating flowBreak permissions inheritance on list itemGrant site owners Full Control permissions if not granted already - it should be granted automatically if you break permission inheritance using HTTP action in flowGrant necessary access to users based on email addresses in person or group column - you can use apply to each for multiple selection person column and inside it grant them accesFollow below links for breaking permissions:Power Automate - Break Inheritance And Set List Item-Level Permissions In SharePoint OnlineStop sharing an item or a fileFollow below links for granting permissions:Grant access to an item or a folderSetting SharePoint Permissions with Power AutomatePlease click Mark as Best Response &amp; Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.For SharePoint/Power Platform blogs, visit:&nbsp;Ganesh Sanap Blogs

Forum Discussion

Restrict Permissions in a List to row where email matches

2 Replies

Resources