Forum Discussion
Read/Write permissions in a SharePoint List
Hello SharePoint community,
I have a SharePoint list as a data source for a timesheet PowerApp I have created. For users to submit their timesheets through the app they require read/write access to the list, this has presented the issue that employees would be able to access the list and make changes to their timesheet such as Approval values (Submitted/Approved/Rejected) and view other employees' timesheets.
Is there a way to set a person's permissions or some workaround so they cannot edit specific columns, see timesheets that aren't their own etc. ?
The approval process is conducted through Power Automate and Approvals, in our use case there isn't any reason for someone, including managers to need to view or edit this list directly.
Any help would be greatly appreciated.
Thanks, Angus
Hi Angus_Ball - for users to only see their own items, this is a List Setting; see this article: How to enable Item Level Permissions in SharePoint | SharePoint Maven.
For users to not be able to edit a column, you have two options:
1. Only allow editing via the Power App, not the List so you can set permissions via the app. See Set up security permissions for a column - Power Platform | Microsoft Learn. And you'll want to suppress the List from search results so they can't still find it to edit. This is an old article but still accurate Exclude SharePoint Site or List from Search Results - SharePoint Diary
2. Replace the current column with a Lookup Column in a new List and set the appropriate permissions on that List. Regardless of accessing via List or Power App, only those with permissions to the Lookup List can use the column.
Both options require updates to the App. I hope that helps!
