Forum Discussion
Exporting list of Team members without coding
Hi, I'm just a regular joe Teams owner - not and IT person. Is there anyway to export the list of members from Teams without coding? (I saw the answer from 2020 about looking at your list of groups i...
Hey Psharer,
With flow you can leverage the Office groups and get a json containing user information and then create a for each that creates a new entry in a table. With this it is possible to create a template file that is a blank table and then fill in all the necessary information.
I do know that there was a list member in the teams connector but at this moment it is not working as intended. This has the ability to use flow to get the team members but at the moment the integration is not working as intended.
The graph api method is still working but maybe cumbersome to achieve without proper API knowledge.
My best bet is on the Office groups and then a for each that adds it to an excel table.
With flow you can leverage the Office groups and get a json containing user information and then create a for each that creates a new entry in a table. With this it is possible to create a template file that is a blank table and then fill in all the necessary information.
I do know that there was a list member in the teams connector but at this moment it is not working as intended. This has the ability to use flow to get the team members but at the moment the integration is not working as intended.
The graph api method is still working but maybe cumbersome to achieve without proper API knowledge.
My best bet is on the Office groups and then a for each that adds it to an excel table.
TimBosch thanks for your response. I'm not an IT person so coding is definitely not my area. I was looking for a simple solution, which either isn't working now as you said or not yet developed.
PSharer If you are just wanting a list of names and email addresses, you could try this:
- Go to https://portal.azure.com/
- In the Search bar, enter the name of the Teams Channel
- Select the Team which should appear under the Microsoft Entra ID section. It should be classified as a group.
- On the left navigation bar, select Members (under Manage).
- On the top horizontal row of tabs, select the drop-down arrow for the Bulk operations tab.
- Select Download members.
I am not aware of any.
Val_S330 thank you, this is so helpful!
- Thank you - just what I needed.
Microsoft - a workaround like this really shouldn't be necessary, being able to download a list of users on a Channel should be a standard feature direct from Teams
