How to BULK GROUPS to a User

Question

Hello,

As part of our onboarding process we are required to create user accounts in Microsoft admin center. Once created, we need to add this user to multiple different groups. The process to do this in the admin center is incredibly frustrating and is driving me crazy! To add each group I have to type in the search field and add EACH GROUP MANUALLY. This is an incredibly inefficient and archaic process. Some users have almost 20-30 groups that they need to be added to! I have a list of group memberships that need to be added to each profile type. Is there a way where I can add multiple groups at once? With on-prem AD in the past I could just copy and paste all groups into the user profile and it would be validated and applied all at once. Is there a way to do this in the admin center or even Azure AD? Is there a Powershell script that can do this?

Please help!

Answer 1

@John Corporal

Thank you for posting this in Microsoft Q&A.

I understand you want to add multiple groups to a user.

Yes, there is a way to add multiple groups to a user account at once using PowerShell.

Below is the PowerShell script.

Creates a CSV file named GroupsList.csv that includes a column for GroupNames

Install-Module AzureAD
Import-Module AzureAD
Connect-AzureAD
$userUPN = "reprouser@r.onmicrosoft.com"
$csvFilePath = "C:\customroles\GroupsList.csv"
$groupNames = Import-Csv -Path $csvFilePath | Select-Object -ExpandProperty GroupNames
foreach ($groupName in $groupNames) {
    Add-AzureADGroupMember -ObjectId (Get-AzureADGroup -Filter "DisplayName eq '$groupName'").ObjectId -RefObjectId (Get-AzureADUser -ObjectId $userUPN).ObjectId
}

Hope this helps. Do let us know if you any further queries.

Thanks,

Navya.

If the answer is helpful, please click "Accept Answer" and kindly "upvote" it.