Bulk add members to Microsoft Teams team from CSV file
Summary
This script will add users in existing Teams contained in your .csv file.
<#
.SYNOPSIS
Add users to a Microsoft 365 group linked to Teams.
.DESCRIPTION
This script will add users in existing Teams contained in your .csv file.
.EXAMPLE
PS C:\> .\add-users-teams.ps1
This script will add users in existing Microsoft Teams teams from your .csv file
.INPUTS
Inputs (if any)
.OUTPUTS
Output (if any)
.NOTES
Your .csv file must contain headers called UPN, teamName, teamId, and role. If you change those headers then make sure to amend the script.
#>
#Check if connected to M365
$m365Status = m365 status
if ($m365Status -match "Logged Out") {
m365 login
}
#Import csv
$usersCsvFile = Import-Csv -Path "<YOUR_CSVFile_PATH_HERE.csv>"
#Add users to the Team
foreach ($row in $usersCsvFile) {
Write-Host "Adding $($row.UPN) to the $($row.teamName) Team" -ForegroundColor Magenta
m365 aad o365group user add --groupId $row.teamId --userName $($row.UPN) --role $($row.role)
}
Check out the CLI for Microsoft 365 to learn more at: https://aka.ms/cli-m365
Source Credit
Sample first appeared on Bulk add members to Microsoft Teams team from CSV file | CLI for Microsoft 365
Contributors
Author(s) |
---|
Inspired by Rakesh Pandey |
Veronique Lengelle |
Disclaimer
THESE SAMPLES ARE PROVIDED AS IS WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING ANY IMPLIED WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE, MERCHANTABILITY, OR NON-INFRINGEMENT.