Forum Discussion

NKS2022's avatar
NKS2022
Copper Contributor
May 18, 2022

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...
microsoft teams
Chair90's avatar
Chair90
Copper Contributor
Aug 03, 2023
I feel for you...why is everything so hard and difficult. MS stop focusing on the shinny objects and build functionality that works and makes sense for users.
PSharer's avatar
PSharer
Copper Contributor
Jan 29, 2024
Agreed! I am supposed to have 180 people in my group but there are only 120. This is a database - why can you not simply right click on members and export to Excel or CSV?!!! There is no simple way to find out which people are missing from my group - this is a time waster for me!
  • TimBosch's avatar
    TimBosch
    Brass Contributor
    Jan 29, 2024
    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.

    • PSharer's avatar
      PSharer
      Copper Contributor
      Jan 30, 2024

      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.

      • Val_S330's avatar
        Val_S330
        Copper Contributor
        Mar 25, 2024

        PSharer If you are just wanting a list of names and email addresses, you could try this:

        1. Go to https://portal.azure.com/
        2. In the Search bar, enter the name of the Teams Channel
        3. Select the Team which should appear under the Microsoft Entra ID section. It should be classified as a group.
        4. On the left navigation bar, select Members (under Manage).
        5. On the top horizontal row of tabs, select the drop-down arrow for the Bulk operations tab.
        6. Select Download members.

Resources