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 in outlook and generating an em from there, but the 2 Teams I'd like to extract members from don't appear in my groups list). thanks!
- If you have admin permissions, you can export the list via the Teams admin center, or PowerShell. If not, it's a bit more complicated. There are some workarounds via Outlook, but those require the Team to be "visible" therein, which doesn't seem to be the case. Instead, consider using a Flow, such as the one here: https://emea.flow.microsoft.com/en-us/galleries/public/templates/2cc5e634806746aba3d303c3e905001c/get-a-weekly-email-with-the-members-of-all-my-office-365-groups/
Or you can open the Team Members page, select all text via CTRL+A, then copy/paste. It will require some cleanup, but at least it doesn't involve using any other tools 🙂WHY IS IT SO F%#F$#@# HARD TO GET A LIST OF MEMBERS FOR A MICROSOFT TEAM? WHY does microsoft make such crap?! WHy not just allow when you're listing the group in teams, something simple -- like copy / paste -- So that you can generate an email, paste the $@$#!# names in and BAM super simple, you've got an email, you can send it to the entire group. I've been F$@!!ing with this for 45 min and still can't send a simple email to my team. Why do I have to go to powershell, run a script or go to any other software other than TEAMS to do this crap?
- 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.
VasilMichev copy and paste puts it into one column for me in Excel - NOT USEFUL!
