cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

List of teams in "Teams" and their owners

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: List of teams in "Teams" and their owners

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.

View solution in original post

4 REPLIES 4
Highlighted
Super User III
Super User III

Re: List of teams in "Teams" and their owners

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

Highlighted
Community Support
Community Support

Re: List of teams in "Teams" and their owners

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.

View solution in original post

Highlighted
Regular Visitor

Re: List of teams in "Teams" and their owners

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.

Highlighted
Community Support
Community Support

Re: List of teams in "Teams" and their owners

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

 

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.

Helpful resources

Announcements
Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Top Solution Authors
Top Kudoed Authors
Users online (5,188)