How to use JSON format, Edit column and conditional column options to show or hide columns based on different users.

Question

Hey there,

I am facing issue on Sharepoint List, I want different users should see different columns based on our requirements.

I have 15 columns so now i want user1 can see only 5 columns, user2 can see 8 columns and user3 can see all 15 columns.

I also want my different user have different access user1 should only have access to atttach file, comment and don't have access to edit all items.

user2 have access to edit all items, etc.

I have created the view for this, for different things but having issues with managing access, I want this to solved on column level.

Basically I want column level security or access to give our users.

Is there any solution for this? I am ready to use json, column edit with formula( Edit column-->column validation--->Formula) or conditional column. I am also ready to use Power automate if needed.

if you have any solution then pls add attachments or Snippet. If not then tell me clearly whether we can do it or not?

Thanks & Regards,

Aman Shaikh.

Answer 1

Hi @AMAN SHAIKH,

Thank you for posting in this community.

First of all, JSON format and conditional column both control the display of this column based on the values of other columns, but not based on the logged-in user.

Second, the minimum level of permissions set in SharePoint is the item (which is a row in a List), and there are no permissions set for columns.

I'm sorry SharePoint doesn't have a way to hide certain columns based on the user at the moment.

Thank you for your kind understanding.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.