Person fields not pulling data from AD

%3CLINGO-SUB%20id%3D%22lingo-sub-167467%22%20slang%3D%22en-US%22%3EPerson%20fields%20not%20pulling%20data%20from%20AD%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-167467%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWe%20have%20an%20Employee%20Directory%20in%20SharePoint.%20It's%20very%20simple%20-%20it's%20a%20list%2C%20and%20it%20is%20supposed%20to%20pull%20data%20like%20Title%2C%20Office%2C%20Mobile%20Phone%2C%20Work%20Phone%2C%20Email%20Address%20etc.%20from%20Active%20Directory%20into%20each%20column.%20The%20columns%20are%20set%20to%20%22Person%20or%20Group%22%2C%20and%20are%20mapped%20to%20each%20of%20the%20corresponding%20data%20points.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMobile%20Phone%20refuses%20to%20update.%20All%20the%20other%20columns%20work%20great%2C%20but%20the%20column%20linked%20to%20%22Mobile%20Phone%22%20always%20comes%20up%20blank%2C%20even%20though%20the%20majority%20of%20our%20users%20have%20mobile%20phones%20entered%20into%20the%20Mobile%20Phone%20field%20in%20Active%20Directory.%20Yes%2C%20I've%20double-checked%20that%20the%20field%20is%20filled%20in%20with%20the%20person's%20name%2C%20so%20it's%20not%20a%20matter%20of%20missing%20data.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI've%20tried%20adding%20this%20column%20to%20several%20lists%20in%20both%20modern%20%26amp%3B%20classic%20SP%2C%20and%20the%20result%20is%20the%20same%20in%20every%20list.%20This%20one%20stupid%20piece%20of%20data%20just%20refuses%20to%20populate.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAny%20ideas%20of%20what%20I%20can%20try%20to%20force%20this%3F%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-167467%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-167581%22%20slang%3D%22en-US%22%3ERe%3A%20Person%20fields%20not%20pulling%20data%20from%20AD%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-167581%22%20slang%3D%22en-US%22%3E%3CP%3EI%20haven't%2C%20but%20I'm%20not%20sure%20how%20to%20go%20about%20doing%20that.%20The%20%22Mobile%20Phone%22%20options%20is%20a%20dropdown%20when%20you%20create%20a%20Person%20column%20in%20SP%20online.%20I'm%20not%20sure%20where%20to%20go%20to%20see%20where%20it's%20pulling%20from.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-167516%22%20slang%3D%22en-US%22%3ERe%3A%20Person%20fields%20not%20pulling%20data%20from%20AD%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-167516%22%20slang%3D%22en-US%22%3EHave%20you%20checked%20the%20field%20itself%2C%20what%20is%20it%20puling%20from%20AD%3F%20The%20mobile%20phone%20field%20is%20just%20%22mobile%22%20need%20to%20make%20sure%20that's%20mapped%20correctly.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-786064%22%20slang%3D%22en-US%22%3ERe%3A%20Person%20fields%20not%20pulling%20data%20from%20AD%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-786064%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F121378%22%20target%3D%22_blank%22%3E%40Caite%20Stevens%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20provide%20more%20information%20on%20how%20you%20created%20this%20list%3F%26nbsp%3B%20I%20am%20attempting%20to%20do%20the%20same.%20I%20created%20a%20new%20list%20and%20I%20have%20a%20couple%20of%20fields%20(Name%2C%20Department%2C%20Title%2C%20etc.)%20Each%20setup%20as%20Person%2FGroup.%26nbsp%3B%20When%20I%20create%20a%20new%20item%20(employee)%2C%20I%20can%20start%20by%20typing%20in%20their%20name%20which%20works%2C%20but%20the%20other%20fields%20do%20not%20populate%20the%20additional%20information.%26nbsp%3B%20Would%20love%20to%20hear%20how%20you%20go%20this%20working.%26nbsp%3B%20Thanks.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-802577%22%20slang%3D%22en-US%22%3ERe%3A%20Person%20fields%20not%20pulling%20data%20from%20AD%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-802577%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F6398%22%20target%3D%22_blank%22%3E%40Jeff%20Harlow%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20long%20as%20that%20info%20is%20in%20AD%2C%20it%20should%20pull%20through.%20I'm%20on%20SP%20online%2C%20which%20may%20be%20the%20difference%20-%20when%20I%20add%20a%20Person%2C%20I'm%20given%20the%20below%20options%20for%20what%20I%20want%20displayed%20in%20that%20field%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F126745iC52F3087202720D3%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-802609%22%20slang%3D%22en-US%22%3ERe%3A%20Person%20fields%20not%20pulling%20data%20from%20AD%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-802609%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F121378%22%20target%3D%22_blank%22%3E%40Caite%20Stevens%3C%2FA%3E%26nbsp%3B%20Yes.%20That%20information%20is%20in%20AD%20(Azure%20AD).%20What%20I%20have%20noticed%20is%20that%20I%20have%20to%20select%20that%20name%20in%20each%20of%20the%20fields%20(Title%2C%20Work%20Phone%2C%20etc.)%20It%20does%20not%20auto%20populate%20all%20of%20the%20fields%20based%20on%20the%20name%20field%20which%20is%20how%20data%20fetching%20usually%20works.%26nbsp%3B%20Did%20you%20witness%20the%20same%3F%26nbsp%3B%20Also%2C%20I%20noticed%20like%20you%20did%2C%20the%20Mobile%20Phone%20does%20not%20work.%26nbsp%3B%20I%20have%20the%20data%20there%20and%20confirmed%20it%20in%20Azure%20AD%20but%20it%20simply%20will%20not%20populate%20that%20data.%26nbsp%3B%20I%20am%20using%20SPO.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-802769%22%20slang%3D%22en-US%22%3ERe%3A%20Person%20fields%20not%20pulling%20data%20from%20AD%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-802769%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20People%20Field%20in%20SharePoint%20is%20an%20interesting%20field...%20it%20doesn't%20pull%20directly%20from%20AD%20%3CEM%3Eper%20se%3C%2FEM%3E.%3CBR%20%2F%3E%3CBR%20%2F%3EThere%20is%20a%20hidden%20list%20on%20every%20site%20collection%20called%20the%20%22User%20Information%20List%22.%20This%20list%20contains%20all%20of%20the%20users%20that%20have%20been%20added%20to%20a%20site%20collection.%20It%20includes%20the%20properties%20from%20their%20user%20profile%20in%20Active%20Directory.%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20People%20Picker%20first%20checks%20to%20see%20if%20the%20Person%20in%20the%20Person%2FGroup%20field%20exists%20in%20the%20User%20Information%20List.%20If%20it%20does%2C%20it%20uses%20the%20values%20from%20this%20list%20for%20the%20%22Show%20Field%22.%20However%2C%20if%20the%20user%20is%20missing%20from%20this%20list%2C%20it%20retrieves%20the%20user%20information%20from%20AD%20and%20adds%20the%20user%20to%20the%20site%20collection%20User%20Information%20List.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3ETheoretically%2C%20this%20list%20should%20update%20from%20a%20timer%20job%20in%20SharePoint...%20but%20it's%20extremely%20common%20that%20it%20does%20not%20update%20correctly.%20You'll%20likely%20find%20blogs%20on%20how%20to%20remove%2Fre-add%20users%20to%20this%20list%20and%2For%20re-sync%20the%20values%20from%20AD.%20I%20actually%20don't%20know%20how%20often%20it%20is%20supposed%20to%20run%20in%20SharePoint%20Online.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-802783%22%20slang%3D%22en-US%22%3ERe%3A%20Person%20fields%20not%20pulling%20data%20from%20AD%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-802783%22%20slang%3D%22en-US%22%3EIt's%20crazy%20to%20think%20that%20SharePoint%20online%2C%20especially%20modern%20web%20parts%20use%20these%20old%20school%20pieces%20of%20original%20SharePoint%20tech.%20You%20would%20think%20they%20would%20update%20or%20have%20that%20webpart%20pull%20from%20graph%20at%20least%20%3A).%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-802977%22%20slang%3D%22en-US%22%3ERe%3A%20Person%20fields%20not%20pulling%20data%20from%20AD%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-802977%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869%22%20target%3D%22_blank%22%3E%40Chris%20Webb%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20frustrating%20because%20if%20we%20are%20using%20SP%20as%20an%20intranet%2C%20one%20of%20the%20first%20things%20people%20want%20to%20see%20is%20an%20Employee%20Directory%2C%20and%20clicking%20on%20Delve%20or%20Teams%20%2Forg%20doesn't%20cut%20it%20as%20a%20replacement.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-802979%22%20slang%3D%22en-US%22%3ERe%3A%20Person%20fields%20not%20pulling%20data%20from%20AD%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-802979%22%20slang%3D%22en-US%22%3Ewell%2C%20again%2C%20searching%20for%20people%20works%20well%20now%2C%20but%20if%20the%20directory%20is%20a%20must%20the%20power%20app%20approach%20is%20easy%20and%20solves%20the%20issue%20better%20than%20trying%20to%20maintain%20a%20static%20people%20list.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-802981%22%20slang%3D%22en-US%22%3ERe%3A%20Person%20fields%20not%20pulling%20data%20from%20AD%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-802981%22%20slang%3D%22en-US%22%3ESounds%20like%20I'm%20going%20to%20have%20to%20learn%20how%20to%20do%20that!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-803023%22%20slang%3D%22en-US%22%3ERe%3A%20Person%20fields%20not%20pulling%20data%20from%20AD%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-803023%22%20slang%3D%22en-US%22%3EYeah%20it's%20not%20too%20hard.%20If%20you%20go%20create%20a%20powerapp%20under%20new%20app%20there%20is%20already%20a%20template%20for%20mobile%20employee%20directory%20%2F%20org%20browser%2C%20you%20can%20either%20use%20that%20one%20as%20is%20or%20use%20the%20logic%20and%20compare%20it%20to%20build%20a%20table%20size%20%2F%20bigger%20size%20version%20of%20it%2C%20but%20at%20least%20you%20can%20see%20how%20the%20app%20works%20from%20the%20mobile%20template%20version.%3C%2FLINGO-BODY%3E
Highlighted
Contributor

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!

 

 

11 Replies
Highlighted
Have you checked the field itself, what is it puling from AD? The mobile phone field is just "mobile" need to make sure that's mapped correctly.
Highlighted

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. 

Highlighted

@Caite Stevens 

 

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. 

 

@Jeff Harlow 

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:

 

clipboard_image_0.png

Highlighted

@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. 

 

 

Highlighted

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.

Highlighted
It's crazy to think that SharePoint online, especially modern web parts use these old school pieces of original SharePoint tech. You would think they would update or have that webpart pull from graph at least :).
Highlighted

@Chris Webb 

 

It's frustrating because if we are using SP as an intranet, one of the first things people want to see is an Employee Directory, and clicking on Delve or Teams /org doesn't cut it as a replacement.

Highlighted
well, again, searching for people works well now, but if the directory is a must the power app approach is easy and solves the issue better than trying to maintain a static people list.
Highlighted
Sounds like I'm going to have to learn how to do that!
Highlighted
Yeah it's not too hard. If you go create a powerapp under new app there is already a template for mobile employee directory / org browser, you can either use that one as is or use the logic and compare it to build a table size / bigger size version of it, but at least you can see how the app works from the mobile template version.