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 giteCommented Oct 21, 2019 at 11:46
Add a comment
|
1 Answer
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 Commented Oct 22, 2019 at 14:01