SharePoint views with restricted access

Ozzie_Koz 21 Reputation points


I have a master SharePoint Lists with various columns and data. What I'd like to accomplish is set a view that only allows a viewer to see a selected number of columns. For example, my master list has 12 columns but I want a view to only show 6 of them which I select. Essentially I would want to share the link to the list that only has the 6 views, and allow the user to update the data in the fields, and have those updates appear on the master list.

I am familiar with creating views but my problem is once I share the link of the list with 12 columns, the view can see all 12. The user would have to click on the filter I created in the view to narrow the list down to 6. I would want them to only see the 6 I select from the moment they click on the list link.

Could I accomplish a view that only shows 6 columns from a master list from the moment a user clicks the link? Would I have to create a separate list and link?

Please kindly advise. Thanks!

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,248 questions
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,865 questions
SharePoint Workflow
SharePoint Workflow
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Workflow: An orchestrated and repeatable pattern of business activity, enabling data transformation, service provision, and information retrieval.
520 questions
0 comments No comments
{count} votes

Accepted answer
  1. Sreeju Nair 11,856 Reputation points

    By default a view inherit permissions from the list. Based on your query, I suggest two options.

    1. Create SPFX webpart that update your List and add the webpart to the page. Use audience targetting feature to display the webpart to certain set of users.
    2. User PowerApps to customize the form.

    Hope this helps

1 additional answer

Sort by: Most helpful
  1. Echo Du_MSFT 17,116 Reputation points

    Hello @Ozzie_Koz ,

    Welcome to Q&A Forum!

    According to your description, you want to restrict view access based on users. Only give users access to view with 6 columns.

    Unfortunately lists/document libraries views does not provide the ability to set specific permissions. Views have never been a securable object in SharePoint. Therefore, there is no OOTB way to meet your needs.

    We suggest that you can go to the Microsoft Tech Community to submit a feedback.

    Here is a similar post for your reference:

    Echo Du


    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.