Forum Discussion
ericxlin
Aug 13, 2020Copper Contributor
teams and bulk adding of members
When I set up a new team or a channel under a team, I noticed that I have to add each name one at a time. It's really tedious, and it seems like an easy add just to cut and paste a bunch of emails fr...
- Aug 13, 2020
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
NikkiChapple_
Aug 31, 2021Iron Contributor
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
kjh123
Nov 10, 2021Copper Contributor
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?
i was wondering, there there a PA workflow that would allow the adding of members into Channels within a Team?
- Nov 10, 2021Hello, no need for that as team members have access to all channels within a team, with the exception of possible private channels.
- kjh123Nov 11, 2021Copper Contributor
Hi, Thank you for your reply.
I am trying to create private channels and add members to those channels - thus the question. (: