Forum Discussion
How to generate a SharePoint List to pull users from Office 365?
Sounds like you're going to want to create an app for this. Use the MS Graph for the User Info - https://docs.microsoft.com/en-us/graph/api/user-list?view=graph-rest-1.0&tabs=http
TimLBthanks for the reply. Taking a few steps back, create an app? As in Power Apps? Our environment is completely O365.
dgillespie-adf Yes, that would be one way. Initiate the creation of the process via a PowerApp - collect the data you need to create the list, then trigger a PowerAutomate workflow to create the list and populate the list with the data from the User Graph API. I think the connector to create the list and pull the user data to the list may be custom connectors and would require some premium licenses to get that accomplished.
So the other app route would be to deploy PnP kind of solution that someone would have to write code to make things happen. Unfortunately, I'm not very familiar with what it would take to do this.
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
