Forum Discussion
SharePoint Online column level permission
In our document library properties we have one column called "Status". This particular column value should be change for the particular people, other people can view only.
Jeyganesh, did you find a solution?
Just thinking out loud to myself here:
What if you had two tables with different permissions?- Table-1 and Table-2 would be nearly identical. However, Table-2 would have a Status column.
- Users would fill in the fields in Table-1 where they are given Contribute rights.
- Workflow copies new row from Table-1 to Table-2 then deletes item from Table-1.
- Managers change status in Table-2 and users only have read access to this table.
Give users a link to the Table-1 form to add content.
Give users a link to the Table-2 list-views to see content.
I also had a thought about lookup fields grabbing calculated column rows from another table and using Javascript to filter on a matching ID. The above seems way simpler.
Jeyganesh Unfortunately, SharePoint doesn't support column level security. There is no way to 100% restrict a user from seeing a field or a value in the field. That is, you could create a custom form in PowerApps that shows and hides a field based on a user.... but it's really security through obscurity.
A user could still create a view (if you give them permission) and find the column, access the column through APIs, or search and other methods.
The best you can do is try to hide it from the most common areas a person would see it.
