SharePoint 2013 List View items permission

Question

There is one SP list (on SP 2013 Foundation) for all users to create their entries (items). Users have their individual departments columns, updated from users' profile details using workflow.

I want to create a list view with filter for all SP List Admins, in which the Admins will be able to view the items created by the users of his department.

The logged in users profile has a field department and I want to match it with the department column of each item in the list.

This will help all Admins to use the common listview but the items will be different based on their departments.

Answer 1

There are couple of ways you can try.

1. Using Current User Filter and list web part connection to match current user's department with the list column (department)

   Source: Use Current User Filter to display items based on User’s Department

2. By changing the filter query of list view using SharePoint designer.

   Source: How to filter SharePoint List based on user permission