How can I create column in SharePoint list to retrieve users from Active directory or user profile service filtered by department?

For example, if user select IT department this column will retrieve all employees at IT only.

  • why do you want to create a column in a list? Do you want to create items which match the filtered department? Can you please explain with an example? – harshal gite Oct 21 '19 at 11:46

I am afraid that we cannot achieve your requirement in the list directly.

You could use search to retrieve users from user profile based on the Department.

For more detailed information, refer to the articles below.

How to Build a Corporate Directory with SharePoint Search.

Creating a Robust Employee Directory Using SharePoint Search.

  • This is fine but not what I mean. I need this functionality in list columns mean that I have custom list that has two columns Department and usernames as drop down columns. when user select Sales as example from department column the usernames column populated with Sales employees only – mohamed gameel Oct 22 '19 at 14:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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