Forum Discussion
Restricting View/Edit/Create of Sharepoint List items to creator only
Hi Team,
I need to build a feedback Power App that can read and write to a Sharepoint Online List held within a Private team ( the HR team for example ). All users need to be able to edit their own records and their managers can update ones assigned to them BUT if they look at the list directly, they are not allowed to see other peoples records.
What is the best way to achieve this level of access control..? Can it be done using SharePoint lists or does it need to be managed through Power Apps/Power Automate somehow..?
2 Replies
jamesanderson You have below SharePoint out of the box approach: Enable item level permissions on SharePoint list from List settings > Advanced settings.
Follow this article for more information: How to Set Item-Level Permissions in a List?
Note: Only item creator will be able to view/edit their list items and manager of creator will not be able to view the records.
Another option:
- Create a power automate flow which will run on item creation or update (as per your requirements)
- Break permissions inheritance on newly created item using power automate flow
- Grant permissions to respective creator of list item and manager.
Follow below article for breaking and granting permissions: Power Automate - Break Inheritance And Set List Item-Level Permissions In SharePoint Online
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.
when i grnt the permission from the flow still the manager cant view his staff items, coz he item level permission ovverriding it , read items that were created by the user
