Sometimes you want to bulk add users to a team. There is an interface to add users but you have to add them one by one:
In some cases you want to add a lot of users. For example you are a teacher and wants to add your students before the start of your classes. Doing this one by one will be very time consuming. So I created a PowerShell script to do this. You don’t need any special permissions to run the script. You only have to be the owner of the team.
First we need a few things:
The teams group Id
Every team (or group) has an unique Id. You can find this by getting the link of the team and search for the groupId parameter in the url:
The url is something like this:
https://teams.microsoft.com/l/team/19%3a544927be176e42efbb0afbf956828ed7%40thread.skype/conversations?groupId=e000eb72-0948-4a89-b1ad-ad708beebbb4&tenantId=1a5763a5-a000-486d-8bed-162db29f5e62 (fake url for security reasons 😉 )
You need to copy the id: e000eb72-0948-4a89-b1ad-ad708beebbb4
Next we need a list with email addresses that you want to add. Store them in a plain text file (input.txt)
The script will use Microsoft Teams and AzureAD commands so make sure you have installed them by running these commands in PowerShell once (open the PowerShell terminal with elevated permissions):
Install-Module -Name MicrosoftTeams
Install-Module -Name AzureADNow we can start, run the following script. You’ll have to enter your credentials a few times.
#change the path to the text file:
$emailaddresses=Get-Content -Path "C:\Users\demouser\input.txt"
#change the ID parameter here
$teamId="GROUP - ID"
# -----------------------------------------
# Run this first
# -----------------------------------------
Set-ExecutionPolicy RemoteSigned
# -----------------------------------------
#not working with MFA accounts
#$crendentials=Get-Credential
Connect-MicrosoftTeams #-Credential $crendentials
Connect-AzureAD #-Credential $crendentials
$team=Get-Team -GroupId $teamId
$groupMembers=(Get-AzureADGroupMember -ObjectId $teamId -All $true | select UserPrincipalName)
#Write-Host $groupMembers
Write-Host "Check current users" -ForegroundColor White
for($i=0; $i -lt $groupMembers.length; $i++){
write-host $groupMembers[$i]
#check if user is in valid user list
#if NO, then delete the user from TEAMS
if($emailaddresses.tolower().Contains($groupMembers[$i].UserPrincipalName.toLower())){
#Write-Host "user found"
}
else{
Write-Host "user not found: remove from TEAMS" -ForegroundColor Red
Remove-TeamUser -groupId $teamId -User $groupMembers[$i].UserPrincipalName
}
}
#add new users
Write-Host "Check user membership" -ForegroundColor White
for($i=0; $i -lt $emailaddresses.length; $i++){
write-host $emailaddresses[$i]
$bUserFound=$false
#check if the user is already in TEAMS
#if NO, then ADD the user
for($j=0; $j -lt $groupMembers.length;$j++){
if($groupMembers[$j].UserPrincipalName.toLower() -eq $emailaddresses[$i].ToLower()){
$bUserFound=$true
#Write-Host "user found in teams members list" -ForegroundColor Yellow
break
}
}
if(!$bUserFound){
Write-Host "adding member to TEAMS" -ForegroundColor Green
Add-TeamUser -GroupId $teamId -User $emailaddresses[$i]
}
}
Feel free to use this!
