Forum Discussion
Person fields not pulling data from AD
Can you provide more information on how you created this list? I am attempting to do the same. I created a new list and I have a couple of fields (Name, Department, Title, etc.) Each setup as Person/Group. When I create a new item (employee), I can start by typing in their name which works, but the other fields do not populate the additional information. Would love to hear how you go this working. Thanks.
- Caite StevensAug 13, 2019Brass Contributor
As long as that info is in AD, it should pull through. I'm on SP online, which may be the difference - when I add a Person, I'm given the below options for what I want displayed in that field:
- Jeff HarlowAug 13, 2019Iron Contributor
Caite Stevens Yes. That information is in AD (Azure AD). What I have noticed is that I have to select that name in each of the fields (Title, Work Phone, etc.) It does not auto populate all of the fields based on the name field which is how data fetching usually works. Did you witness the same? Also, I noticed like you did, the Mobile Phone does not work. I have the data there and confirmed it in Azure AD but it simply will not populate that data. I am using SPO.
- Beau CameronAug 13, 2019MVP
The People Field in SharePoint is an interesting field... it doesn't pull directly from AD per se.
There is a hidden list on every site collection called the "User Information List". This list contains all of the users that have been added to a site collection. It includes the properties from their user profile in Active Directory.
The People Picker first checks to see if the Person in the Person/Group field exists in the User Information List. If it does, it uses the values from this list for the "Show Field". However, if the user is missing from this list, it retrieves the user information from AD and adds the user to the site collection User Information List.
Theoretically, this list should update from a timer job in SharePoint... but it's extremely common that it does not update correctly. You'll likely find blogs on how to remove/re-add users to this list and/or re-sync the values from AD. I actually don't know how often it is supposed to run in SharePoint Online.