You’re offline. This is a read only version of the page.
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
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!
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.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.
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.
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.
@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.
#1
David_MA
216
Super User 2025 Season 1
#2
Michael E. Gernaey
213
Super User 2025 Season 1
#3
stampcoin
186
Share
Report
All responses (
Answers (