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.
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
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.