Skip to main content

Bulk add/remove users to Microsoft Teams and Microsoft 365 Groups

Author: Joseph Velliah

Companies pursue to hasten profits growth or enter new marketplace through Mergers and Acquisitions (M&A). M&A typically fails during integration. This also applies to migrating users and data in Microsoft Teams and Groups. Partial acquisition can be pretty tricky. To help make the activity as charming as possible, I have created the following sample script to add/remove bulk users to/from Microsoft Teams team or Microsoft 365 group using CLI for Microsoft 365 commands.

Note: Refactor the code as per your requirement.

$taskItems = import-csv "sample-input-file.csv" –header mailNickname, userEmail, role, action
$groups = m365 entra m365group list -o json | ConvertFrom-Json

ForEach ($taskItem in $taskItems) {

$mailNickname = $($taskItem.mailNickname)
$userEmail = $($taskItem.userEmail)
$role = $($taskItem.role)
$action = $($taskItem.action)

$group = $groups | Where-Object { $_.mailNickname -eq "$mailNickname" }
$user = m365 entra user get --userName $userEmail -o json | ConvertFrom-Json

Write-Host "Processing: User --> " $user.mail " Group --> " $group.mailNickname

If ($action -eq "add") {

If ($role -eq "owner") {
m365 entra m365group user add --groupId $ --userName $user.mail --role Owner
Write-Host $user.mail " added as owner in " $group.mailNickname
ElseIf ($role -eq "member") {
m365 entra m365group user add --groupId $ --userName $user.mail
Write-Host $user.mail " added as member in " $group.mailNickname
Else {
Write-Host "Invalid user role '" $role "'"
ElseIf ($action -eq "remove") {
m365 entra m365group user remove --groupId $ --userName $user.mail --force
Write-Host $user.mail " removed from " $group.mailNickname
Else {
Write-Host "Invalid task action '" $action "'"