Forum Discussion

RJF61's avatar
RJF61
Copper Contributor
Jul 28, 2022
Solved

SharePoint/MS Lists Views

Hello,

I have a SharePoint list where employees enter data via MS Lists.  There is a significant amount of information from many employees so I want the user to only see their information in MS Lists.  As the administrator of the site, I want to see all data.  Is there a way to filter the view so the user is only able to see their info and I can see all?

  • RJF61

    There are 2 ways of doing it

    1. Update your default view to filter items created by self. Set Created = [Me] which will filter out all items and display only items created by logged in user. This will not prevent users from changing views or creating new view to access all items. 
    2. Second option is using item level permissions. Go to list settings -> Advanced settings -> Item-level permissions -> By setting 'Read items that were created by the user' & 'Create items and edit items that were created by the user' users are restricted to read/edit items only created by them. As admin with full control permission, you will still be able to view all items. This approach updates permissions at item level and there is no way for users to access items that are not created by them.

     

     

3 Replies

  • Bharath Arja's avatar
    Bharath Arja
    Iron Contributor

    RJF61

    There are 2 ways of doing it

    1. Update your default view to filter items created by self. Set Created = [Me] which will filter out all items and display only items created by logged in user. This will not prevent users from changing views or creating new view to access all items. 
    2. Second option is using item level permissions. Go to list settings -> Advanced settings -> Item-level permissions -> By setting 'Read items that were created by the user' & 'Create items and edit items that were created by the user' users are restricted to read/edit items only created by them. As admin with full control permission, you will still be able to view all items. This approach updates permissions at item level and there is no way for users to access items that are not created by them.

     

     

    • RJF61's avatar
      RJF61
      Copper Contributor
      Thank you. This was perfect.
  • David_Petree's avatar
    David_Petree
    Brass Contributor
    Yes

    https://support.microsoft.com/en-us/office/create-change-or-delete-a-view-of-a-list-or-library-27ae65b8-bc5b-4949-b29b-4ee87144a9c9

Resources