Forum Discussion
Export list of all users from a group chat
- Mar 25, 2024
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.
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.