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.

1 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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.