Forum Discussion
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 Teams without having to manually lookup on the old group chat and invite them on the new Teams channel? I was wondering if there is a PowerShell to extract the email of all group chat users into a .csv. Later I can simply automatically use PowerShell to add them to the Teams.
Any other creative solution is appreciated
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.
