Office 365 User profile to SharePoint online list

%3CLINGO-SUB%20id%3D%22lingo-sub-783451%22%20slang%3D%22en-US%22%3EOffice%20365%20User%20profile%20to%20SharePoint%20online%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-783451%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EWe%20are%20using%20Office%20365%20with%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3ESharePoint%20Online%20(Plan%201)%20package.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EWe%20would%20like%20to%20create%20the%20SharePoint%20list%20from%20our%20Office%20365%20User%20profile.%26nbsp%3B%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EFor%20example%20in%20our%20office%20365%20account%20has%2030%20users%2C%20all%20these%20user%20profiles%20need%20to%20display%20in%20our%20SharePoint%20list.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3Ehow%20can%20we%20do%20this%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-783451%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-783778%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%20User%20profile%20to%20SharePoint%20online%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-783778%22%20slang%3D%22en-US%22%3EMicrosoft%20flow.%20%3CBR%20%2F%3E%3CBR%20%2F%3ECreate%20the%20list%20and%20the%20columns%20you%20will%20want%20from%20the%20profile.%20Then%20Setup%20a%20timer%20job%20assuming%20these%20need%20to%20be%20updated.%20And%20you%20can%20create%20a%20job%20to%20clear%20out%20the%20list%20and%20import%20from%20the%20office%20365%20users%20connector.%20This%20should%20be%20able%20to%20be%20looped%20through%20and%20then%20add%20a%20SharePoint%20action%20to%20create%20a%20new%20list%20item%20for%20each%20of%20the%20users%20in%20the%20loop%20with%20selected%20data.%20%3CBR%20%2F%3E%3CBR%20%2F%3EThat%E2%80%99s%20the%20high%20level%20approach%20I%20would%20take%20to%20solve%20this.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-787652%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%20User%20profile%20to%20SharePoint%20online%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-787652%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%3ECan%20you%20please%20provide%20the%20example%20for%20%22%3CSPAN%3ESetup%20a%20timer%20job%22%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-807104%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%20User%20profile%20to%20SharePoint%20online%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-807104%22%20slang%3D%22en-US%22%3ESorry%2C%20missed%20this%20response.%20When%20you%20create%20a%20flow%2C%20there%20are%20base%20started%20templates%2C%20one%20is%20for%20reoccuring%20or%20on%20a%20timer.%20Forget%20what%20it's%20called%2C%20but%20it%20basically%20starts%20with%20a%20Repeating%20Reoccuring%20trigger%20that%20you%20can%20run%20on%20schedule.%3C%2FLINGO-BODY%3E
Highlighted
Contributor

We are using Office 365 with SharePoint Online (Plan 1) package.

 

We would like to create the SharePoint list from our Office 365 User profile. 

For example in our office 365 account has 30 users, all these user profiles need to display in our SharePoint list.

 

how can we do this?

 

 

3 Replies
Highlighted
Microsoft flow.

Create the list and the columns you will want from the profile. Then Setup a timer job assuming these need to be updated. And you can create a job to clear out the list and import from the office 365 users connector. This should be able to be looped through and then add a SharePoint action to create a new list item for each of the users in the loop with selected data.

That’s the high level approach I would take to solve this.
Highlighted

@Chris Webb 

 

Can you please provide the example for "Setup a timer job"?

Highlighted
Sorry, missed this response. When you create a flow, there are base started templates, one is for reoccuring or on a timer. Forget what it's called, but it basically starts with a Repeating Reoccuring trigger that you can run on schedule.