Get all AAD Users with manager in a sharepoint list

(0) Share

Report

Posted on by Community Power Pla...

Hello all,

I would like to build a flow with which I can retrieve all AAD / Office users including managers of the users into a Sharepoint List. How is this feasible?

Thanks for your Help

Jan

All responses (1)

Answers (1)

Verified answer

DAllen365 446 on at

Like (0)

Report

Re: Get all AAD Users with manager in a sharepoint list

Jan, is this for a one-time task or you need to be repeatable? There are likely multiple methods available including PowerShell, but this should be possible in a flow. From what I remember the Azure AD actions are limited, but you could use the Office 365 Search for Users connector then do a foreach loop, use get manager passing in the ID or email of the user to get their manager, then do a create item to write the data to a SharePoint list.

Similar requests
https://powerusers.microsoft.com/t5/Building-Flows/Get-all-users-through-Office-365-Users-connector-through-Search/td-p/434881
https://powerusers.microsoft.com/t5/Building-Flows/Get-a-list-of-ALL-User-Profiles-and-there-is-much-more-than-100/td-p/179497

----------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.