Populte Department and related Employee Name from AD in SharePoint Custom List

Question

I Created a custom list and it has below columns

Appointment Date and Time Department Employee

Her I want to Populate Departments from Company and when I select specific department related employees will populate in employee dropdown.

How can i achieve this any way do this by out of the box or i must write farm solution for this. I created User profile service application.

Answer 1

@adil

Per my knowledge, there is no OOTB option to get Department and Employee Name from AD into columns of a list.

As a workaround, you could create another list to store Department and Employee Name. Then create a lookup column to get Department when you select specific Employee Name.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

there is no OTB solution for that. As far as I understood you work with on-prem version. You already configured User Profile Service app which is good. Now you need to run sync and ensure that user profiles are populated from AD and have Department set. After that you will need custom timer job (or PowerShell script which will run periodically by schedule): it should go through all user profiles programmatically and synchronize changes to your custom list (if you will sync users to lists once - then changes in AD won't reflect in your lists). You may start e.g. with this example: Get all user profiles to list.