Forum Discussion
teams and bulk adding of members
Feedback URL for this (Updated Dec 2021)
Allow bulk adding of team members via .csv file. · Community (microsoft.com)
To be able to bulk add via CSV
Another way you can do it today, if you are an administrator and now how, is Powershell. You can do this with the Teams Powershell module. Lots of guides online. Gallery herePowerShell Gallery | MicrosoftTeams 3.0.0
Alternatives are groups or Power Automate
Hope that answers your question
Best, Chris
ericxlin have you thought about using Power Automate.
- Create a table in a Excel sheet with your list of email addresses to be added to the team
- Create flow as described below
- Get the list of rows from the excel sheet and table
- Add member to a Team and select your team (this will automatically add the Apply to each step. This will repeat 1 to N times for each row of the Excel sheet and add member to Team)
- Then run flow and the users in the list are added to the team
- This worked well! Thanks
This worked awesomely .. saved my few hours of Ctrl+C+V !!.
More Screen instructions from my Flow which I managed to get to work.
( Note: Insert Table in Excel with only email values )
Step 1:
Step 2:
Step 3:
Sample Excel :
Run:
- nikkichapple. could you pls expand or provide a link to teach how to do flows? I've found the power apps/new flow link. BUt then there's diff types of flows to choose from...? Tried a couple and typed in "list rows present in a table" but nothing came up. Help please?
Hi Nikki,
Found how to start the creation of a flow as per your image - but got stuck at adding the 'email'
in the teams section. Do you have advice for this step please?
- and...continuing to answer my own question in case it helps others; mine wasn't working bec i didn't 'format as table'. I found Nikki's blog which helped! https://nikkichapple.com/use-power-automate-to-bulk-add-members-into-microsoft-teams/
Thanks for the flow. Unfortunately, it doesn't seem to work with external people as the "Add a member" action asks for the AAD ID. It wants users it already knows 😛
My flow fails with the error message : "User '65237ea-7d72-a409-f59cfa6d2acb' does not exist."
Chris365 You can add an name, distribution list or Security Group - you can add a name of a team - e.g. distribution list of PMs - and it will append all of the people in the list. Also prompting you whom of the list were already in the team. Not sure if that helps at all!
Chris365 The flow is designed to bulk add internal users into Teams. So the users already need to have accounts in Azure AD. This link might be useful for bulk loading guest users into Azure AD Tutorial for bulk inviting B2B collaboration users - Azure Active Directory - Microsoft Entra | Microsoft Docs
- this is an awesome post! saved me from having to add about 1000 accounts into Teams.
i was wondering, there there a PA workflow that would allow the adding of members into Channels within a Team?- Hello, no need for that as team members have access to all channels within a team, with the exception of possible private channels.
Hi, Thank you for your reply.
I am trying to create private channels and add members to those channels - thus the question. (:
NikkiChapple_ This worked GREAT! Thank you soo much! I have multiple projects expecting me to bulk load large team members as we migrate our activities into the Teams platform. This has enabled me to go forward without waiting for a corporate administrator's support.
