cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JanHohnroth
Helper I
Helper I

Get all AAD Users with manager in a sharepoint list

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

1 ACCEPTED SOLUTION

Accepted Solutions
DAllen365
Resolver V
Resolver V

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-...

https://powerusers.microsoft.com/t5/Building-Flows/Get-a-list-of-ALL-User-Profiles-and-there-is-much...


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

View solution in original post

1 REPLY 1
DAllen365
Resolver V
Resolver V

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-...

https://powerusers.microsoft.com/t5/Building-Flows/Get-a-list-of-ALL-User-Profiles-and-there-is-much...


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

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,194)