How to generate a SharePoint List to pull users from Office 365?

%3CLINGO-SUB%20id%3D%22lingo-sub-1333124%22%20slang%3D%22en-US%22%3EHow%20to%20generate%20a%20SharePoint%20List%20to%20pull%20users%20from%20Office%20365%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1333124%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%20created%20some%20great%20SharePoint%20lists%20for%20deployment%20purposes%20and%20the%20one%20SWEET%20function%20I%20would%20like%20to%20see%20is%20every%20time%20we%20generate%20a%20new%20SP%20list%2C%20it%20populates%20the%20Name%20field%20with%20users%20from%20Office%20365%20based%20on%20the%20location.%26nbsp%3B%20This%20would%20allow%20us%20to%20get%20active%20user%20lists%20instead%20of%20manually%20adding%20them.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOne%20workaround%20we%20know%20works%20now%20is%20to%20export%20the%20users%20from%20Office%20365%20into%20a%20csv%20file%20and%20then%20import%20them%20into%20the%20list.%26nbsp%3B%20I%20would%20like%20this%20%22process%22%20to%20happen%20automatically%20when%20the%20list%20is%20created.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1333124%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1333313%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20generate%20a%20SharePoint%20List%20to%20pull%20users%20from%20Office%20365%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1333313%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F106222%22%20target%3D%22_blank%22%3E%40Derek%20Gillespie%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESounds%20like%20you're%20going%20to%20want%20to%20create%20an%20app%20for%20this.%20Use%20the%20MS%20Graph%20for%20the%20User%20Info%20-%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fgraph%2Fapi%2Fuser-list%3Fview%3Dgraph-rest-1.0%26amp%3Btabs%3Dhttp%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fgraph%2Fapi%2Fuser-list%3Fview%3Dgraph-rest-1.0%26amp%3Btabs%3Dhttp%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1333893%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20generate%20a%20SharePoint%20List%20to%20pull%20users%20from%20Office%20365%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1333893%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F228093%22%20target%3D%22_blank%22%3E%40Timothy%20Balk%3C%2FA%3Ethanks%20for%20the%20reply.%26nbsp%3B%20Taking%20a%20few%20steps%20back%2C%20create%20an%20app%3F%26nbsp%3B%20As%20in%20Power%20Apps%3F%26nbsp%3B%20Our%20environment%20is%20completely%20O365.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1335646%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20generate%20a%20SharePoint%20List%20to%20pull%20users%20from%20Office%20365%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1335646%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F106222%22%20target%3D%22_blank%22%3E%40Derek%20Gillespie%3C%2FA%3E%26nbsp%3BYes%2C%20that%20would%20be%20one%20way.%20Initiate%20the%20creation%20of%20the%20process%20via%20a%20PowerApp%20-%20collect%20the%20data%20you%20need%20to%20create%20the%20list%2C%20then%20trigger%20a%20PowerAutomate%20workflow%20to%20create%20the%20list%20and%20populate%20the%20list%20with%20the%20data%20from%20the%20User%20Graph%20API.%20I%20think%20the%20connector%20to%20create%20the%20list%20and%20pull%20the%20user%20data%20to%20the%20list%20may%20be%20custom%20connectors%20and%20would%20require%20some%20premium%20licenses%20to%20get%20that%20accomplished.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20the%20other%20app%20route%20would%20be%20to%20deploy%20PnP%20kind%20of%20solution%20that%20someone%20would%20have%20to%20write%20code%20to%20make%20things%20happen.%20Unfortunately%2C%20I'm%20not%20very%20familiar%20with%20what%20it%20would%20take%20to%20do%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

We have created some great SharePoint lists for deployment purposes and the one SWEET function I would like to see is every time we generate a new SP list, it populates the Name field with users from Office 365 based on the location.  This would allow us to get active user lists instead of manually adding them.

 

One workaround we know works now is to export the users from Office 365 into a csv file and then import them into the list.  I would like this "process" to happen automatically when the list is created.

 

Any ideas?

3 Replies
Highlighted

@Derek Gillespie 

 

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

Highlighted

@Timothy Balkthanks for the reply.  Taking a few steps back, create an app?  As in Power Apps?  Our environment is completely O365.

Highlighted

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