Forum Discussion

S_S_Ramana's avatar
S_S_Ramana
Bronze Contributor
Mar 12, 2017

Column / Field level security

Hello Folks,

 

Is it possible to restrict some people from viewing / accessing certain columns on a sharepoint list based on role / permissions?

We have seen this available in Lotus Notes and Im aware this is not possible on on-premise but was wondering if a similar functionliaty is now available on O365.

 

  • gauravmahajan's avatar
    gauravmahajan
    Brass Contributor
    I realize this is an old thread but if it helps other's in the future, the only way to do this is to setup separate lists, one which has the column and the other which does not. Then use Power Automate or Event Receivers to synchronize information between the two lists. This is the only true way of "mimicking" column level permissions.
    HTH!
  • Marcus0122's avatar
    Marcus0122
    Copper Contributor

    S_S_Ramana 

    Yes you could manage it. unless...

    1. create a non public view and hide the column you want to protect

    2. set a permission without manage the list and can not create personal view

    3. add the user to this permission and remove the default permission.

     

    then the user can not see the column

  • You will find a lot of articles on the internet solving this problem. Be aware that none of them actually apply security to the underlying data store. A custom form will hide fields, but will not prevent users from seeing the data using the OOB SharePoint views.

  • Dean_Gross's avatar
    Dean_Gross
    Silver Contributor

    You can use form design tools such as InfoPath, PowerApps, Nintex Forms to accomplish this type of functionality.

  • JaredMatfess's avatar
    JaredMatfess
    Iron Contributor

    Unfortunately, there is no column/field based security in SharePoint. 

    • jcgonzalezmartin's avatar
      jcgonzalezmartin
      MVP
      SharePoint OnPremises and SharePoint Online share the same code base and as Jared has said, SharePoint has never had column / field shared security...however you could achieve this by means of custom development

Resources