SOLVED

SharePoint Online list - pull data from Azure AD

%3CLINGO-SUB%20id%3D%22lingo-sub-3542025%22%20slang%3D%22en-US%22%3ESharePoint%20Online%20list%20-%20pull%20data%20from%20Azure%20AD%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3542025%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20are%20fully%20O365.%20We%20have%20Azure%20Ad%20and%20SharePoint%20Online.%20I%20have%20created%20a%20list.%20In%20the%20name%20column%20I%20want%20users%20to%20be%20able%20to%20start%20typing%20a%20users%20name%20and%20it%20pull%20that%20data%20from%20Azure%20AD.%20So%20if%20someone%20filling%20in%20the%20form%20wanted%20to%20enter%20John%20Smith%20in%20to%20the%20Name%20column%2C%20as%20they%20start%20typing%20Joh...%20it%20would%20fetch%20the%20data%20from%20Azure%20AD%20and%20present%20a%20dropdown%20of%20users%20meeting%20that%20pattern.%20Sounds%20simple%20but%20I%20cant%20figure%20it%20out.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20put%20it%20simpler%2C%20how%20can%20we%20use%20the%20Lookup%20column%20type%20to%20fetch%20data%20from%20Azure%20AD.%20Currently%20it%20only%20allows%20to%20lookup%20%22information%20already%20on%20this%20site%22%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3542025%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3542733%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Online%20list%20-%20pull%20data%20from%20Azure%20AD%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3542733%22%20slang%3D%22en-US%22%3EI%20am%20not%20sure%20--%20but%20isn't%20the%20people%20picker%20suitable%20for%20this%3F%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.sharepointdiary.com%2F2016%2F08%2Fsharepoint-online-add-person-or-group-column-to-list-using-powershell.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.sharepointdiary.com%2F2016%2F08%2Fsharepoint-online-add-person-or-group-column-to-list-using-powershell.html%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DD4-isq2F8Mo%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DD4-isq2F8Mo%3C%2FA%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3543047%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Online%20list%20-%20pull%20data%20from%20Azure%20AD%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3543047%22%20slang%3D%22en-US%22%3EThanks%20very%20much%20for%20this.%20I%20chose%20the%20Person%20or%20Group%20option%2C%20selected%20All%20Users.%20Now%20when%20a%20user%20fills%20in%20the%20form%2C%20they%20type%20the%20first%20few%20letters%20of%20the%20name%20and%20it%20autofills%20in%20the%20rest.%20Exactly%20what%20I%20was%20after.%20Thanks%20again.%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi all.

 

We are fully O365. We have Azure Ad and SharePoint Online. I have created a list. In the name column I want users to be able to start typing a users name and it pull that data from Azure AD. So if someone filling in the form wanted to enter John Smith in to the Name column, as they start typing Joh... it would fetch the data from Azure AD and present a dropdown of users meeting that pattern. Sounds simple but I cant figure it out.

 

To put it simpler, how can we use the Lookup column type to fetch data from Azure AD. Currently it only allows to lookup "information already on this site"

2 Replies
best response confirmed by rapid_f1 (Occasional Contributor)
Thanks very much for this. I chose the Person or Group option, selected All Users. Now when a user fills in the form, they type the first few letters of the name and it autofills in the rest. Exactly what I was after. Thanks again.