Forum Discussion
How to generate a SharePoint List to pull users from Office 365?
Without delving into learning PowerApps just yet, is there a simple way to ask Sharepoint to auto load employee information like name, email, or dept based on Azure Active Directory information?
Currently, I can search/find employees and add them to Sharepoint List column by searching for them using a company email address. We also have unique identifiers like employee numbers that I'd like to use instead.
1) How can I instruct SP to search for a person based on this number instead of their email address? 2) How can I link columns for "auto filling" subsequent columns with name, email, dept, etc from the unique number in Azure?
Appreciate your insight and thank you!
ninjaryder actually I'd say that using Power Apps is your best option; it's not difficult to get or search for employees. We use it for a staff search app I built where you can enter the first letters of a name, job title, location or team name to bring back all the data on the employee(s) from Delve. We have over 1000 staff in our division and it runs very quickly. There are a lot of very good videos about Power Apps by Shane Young on YouTube and I recommend you have a look at those.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
- @RobElliot, How did you get around delegation issues? How did you get the information from Delve rather than O365 users? I am building an app where my data source is 365 connector and I am only retrieving some of the records and it's driving me bonkers.
