Answered

List of teams in "Teams" and their owners

(0) Share

Report

Posted on by sigalou

Hello,
I have been trying for days to do something simple but I can't do it.
I would like to create an Excel table which would display the list of teams and for each the name of the owner.
I can't do it.
I found to list the teams

But where can I find who owns the team?

thank

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

RobElliott 10,323 Super User 2025 Season 2 on at

Like (0)

Report

@sigalou there's no way to do this with Power Automate as although your list your Teams you can't get a list across your entire tenant or find out who the owner of each Team is. I believe this can be done by a global admin with PowerShell but I don't know the details.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Was this reply helpful? Yes No
Verified answer

v-litu-msft on at

Like (0)

Report

Hi @sigalou,

I agree with @RobElliott, there is no action could get the team owner via Power Automate currently, you could use Powershell to Acchive it, there is a blog could help you:

https://www.c-sharpcorner.com/blogs/how-to-get-the-team-owners-from-all-the-teams-using-powershell

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
sigalou 13 on at

Like (0)

Report

I'm going to test this, to tell the truth, I started by trying with Powershell and I got there thanks to these two sites:
https://www.jijitechnologies.com/blogs/get-microsoft-teams-details
https://www.quadrotech-it.com/blog/how-to-manage-microsoft-teams-powershell-and-the-graph/
Your link completes the information, thank you.
Do you know if it was possible to launch a Powershell script other than by manually opening the powershell window? (With a Teams or Flow module or other?)
Thanks again.

Was this reply helpful? Yes No
v-litu-msft on at

Like (0)

Report

Hi @sigalou,

As far as I know, there is no PowerShell could just launch a Powershell script other than by manually opening the PowerShell window, at least need to do is open the PowerShell window and load a script file:

https://www.cbtnuggets.com/blog/certifications/microsoft/first-steps-to-it-automation-with-powershell

https://www.windowscentral.com/how-create-and-run-your-first-powershell-script-file-windows-10

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Cat Schneider 488 Most Valuable Professional on at

Like (3)

Report

Hi there @sigalou, I was just looking for something similar that I could send a request to Power Automate from a Power App. I know my reply is probably WAY later than you were hoping to get a clean solution, but maybe it will help out others looking for something similar...

Turns out there is a way to lookup just group owners using the Graph API: https://graph.microsoft.com/v1.0/groups/{group-id}/owners

In Power Automate select the 'Send an HTTP request' connector from the 'Office 365 Groups' connector set, drop in the URI unique to the group you want to return the owners for, and make sure the Method is set to "GET".

Et voilà, the output returned is restricted to just Group owners. 😊 I hope this information is able to help you and others out!

Was this reply helpful? Yes No