Share Point Permissions

Copper Contributor

Hello dear community,

I have a question regarding share point lists.


I created four groups in the Microsoft 365 admin center and filled them with members.
(Purchasing, sales, quality assurance and technology)

I now have a list with a Group Membership field. The members of the Purchasing group should see all items, but the members of the other three groups should only see items if the Group membership field also contains the appropriate value.

For example: Sales members should only see items if the value in the Group Membership field equals "Sales".


I hope I explained my problem clearly.
Thank you in advance and Happy Holidays.

1 Reply

@Thomas_Scharf You can use Power automate flow on item creation/update which will break list item permissions and grant permissions to groups based on selection in "Group Membership" field.


Check my answer on this thread & see if it helps: View/edit rows in SharePoint List that only relevant to the specific team 


Related readSharePoint Online: Grant Permissions to Azure AD Security group using Power Automate and REST API 

Please click Mark as Best Response & 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.