Forum Discussion
Person fields not pulling data from AD
Hi !
We have an Employee Directory in SharePoint. It's very simple - it's a list, and it is supposed to pull data like Title, Office, Mobile Phone, Work Phone, Email Address etc. from Active Directory into each column. The columns are set to "Person or Group", and are mapped to each of the corresponding data points.
Mobile Phone refuses to update. All the other columns work great, but the column linked to "Mobile Phone" always comes up blank, even though the majority of our users have mobile phones entered into the Mobile Phone field in Active Directory. Yes, I've double-checked that the field is filled in with the person's name, so it's not a matter of missing data.
I've tried adding this column to several lists in both modern & classic SP, and the result is the same in every list. This one stupid piece of data just refuses to populate.
Any ideas of what I can try to force this?
Thanks!
I am experiencing the same problem in SharePoint 2019. A simple list of contacts contains three columns: Name, Department, and Phone. All 3 columns are of type Person or Group. When we add an item to the list, we pick the person in all 3 fields. For the Name column, the Show field is set to "Name (with presence)". For Department, "Department". For the Phone column, the Show field is set to "WorkPhone". The Name and Department fields display ok but the WorkPhone field is blank. I verified the WorkPhone field is populated correctly in AD and also in the User Profile Service which is synchronizing from AD. I note the WorkPhone field is not available in the hidden User Information List. This worked fine in SharePoint 2013. Is there a bug?
- Did you find any solution to this even I am facing the same issue
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.
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:
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.
I haven't, but I'm not sure how to go about doing that. The "Mobile Phone" options is a dropdown when you create a Person column in SP online. I'm not sure where to go to see where it's pulling from.
