Forum Discussion

Roli307's avatar
Mar 08, 2022
Solved

Export list of all users from a group chat

Greetings I have created a Teams group chat with 100 people. Now I have decided to create a Teams channel and move the discussion. How do I add all people from the old Teams group chat to the new ...
  • jmizin's avatar
    jmizin
    Mar 25, 2024

    FrustrationTeams1012 @Roli307 

     

    Hello!

    An old topic, but perhaps someone (like me) will come across it, ask themselves the same question and want a simple ready-made answer.

    So, what worked for me was:

    1) right click on a message from the group chat and select "copy link", then paste it to notepad and extract the Chat ID (e.g. 19:b8577894a63548969c5c92bb9c80c5e1@thread.v2)
    (as described here: https://answers.microsoft.com/en-us/msteams/forum/all/get-chat-id-in-new-teams/dd9788d3-1f5a-4da4-9fc8-cc3f35f03dba )

    2) go to https://developer.microsoft.com/en-us/graph/graph-explorer and sign in

    3) use the command as posted by @Vasil Michev (just paste the HTTPS part): https://graph.microsoft.com/beta/chats/19:b8577894a63548969c5c92bb9c80c5e1@thread.v2?$expand=members

    4) copy the response to Excel and post-process it to get the members' names, e.g. using INDEX to list every 12-th row content (with the names) and MID or SUBSTITUTE to get just the name without the "displayName" part.

Resources