How to Bulk Import CSV to create Security Groups and Add Groups Owner to those Groups Using Powershell in Azure AD

I get this Error after running this - Import-Csv -Path "C:\temp\GroupsC.csv" | ForEach-Object {
Get-AzureADUser -ObjectId $_.GroupOwner
}

Get-AzureADUser : Cannot bind argument to parameter 'ObjectId' because it is an empty string.
At line:2 char:32

• Get-AzureADUser -ObjectId $_.GroupOwner
• ~~~~~~~~~~~~~
• CategoryInfo : InvalidData: (:) [Get-AzureADUser], ParameterBindingValidationException
• FullyQualifiedErrorId : ParameterArgumentValidationErrorEmptyStringNotAllowed,Microsoft.Open.AzureAD16.PowerShell.GetUser

Get-AzureADUser : Cannot bind argument to parameter 'ObjectId' because it is an empty string.
At line:2 char:32

• Get-AzureADUser -ObjectId $_.GroupOwner
• ~~~~~~~~~~~~~
• CategoryInfo : InvalidData: (:) [Get-AzureADUser], ParameterBindingValidationException
• FullyQualifiedErrorId : ParameterArgumentValidationErrorEmptyStringNotAllowed,Microsoft.Open.AzureAD16.PowerShell.GetUser

This is weird .....

Please run each line and post each output:

($PSVersionTable).PSVersion  
Get-InstalledModule AzureAD | Select-Object Name, Version, Repository  
Import-Module AzureAD # This will not give an output  
Get-Module AzureAD | Select-Object Name, Version  
(Get-AzureADCurrentSessionInfo).Account  

Please verify the user of the last output is a member of the Global Administrator role in your Azure AD.

Also you could run the following command with using your Azure AD Account:

Get-AzureADUser -ObjectId "******@group.com"  

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten

Please find the result :

PS C:\Windows\system32> ($PSVersionTable).PSVersion
Get-InstalledModule AzureAD | Select-Object Name, Version, Repository

Major Minor Build Revision
----- ----- ----- --------
5 1 19041 1682

Name : AzureAD
Version : 2.0.2.140
Repository : PSGallery

Import-Module AzureAD

PS C:\Windows\system32> Import-Module AzureAD

PS C:\Windows\system32> Get-Module AzureAD | Select-Object Name, Version
(Get-AzureADCurrentSessionInfo).Account

Name Version
---- -------
AzureAD 2.0.2.140

What happens if you please run this now (using your Azure AD account as the ObjectId)?

Get-AzureADUser -ObjectId "******@group.com"  

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten

I Get this Result :

PS C:\Windows\system32> Get-AzureADUser -ObjectId ******@group.com

ObjectId DisplayName UserPrincipalName UserType
-------- ----------- ----------------- --------
bffsdffc8-43482-4434a-9343a-44555sd Mourya, Aditya ******@group.com Member

Next try please:

Import-Csv -Path "C:\temp\GroupsC.csv" | ForEach-Object {  
    Write-Output "Owner: $($_.GroupOwner)"  
    $ownerUserObj = Get-AzureADUser -ObjectId ($_.GroupOwner).Trim()  
    $ownerUserObj  
}  

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten

Please see attached my CSV file contain.. these header

@Andreas Baumgarten

Hi @Mourya, Aditya ,

please post the output of this line (replace <yourCSVfileName.csv> with the name of your CSV file):

Import-Csv -Path "<yourCSVfileName.csv>"   

You should see 2 lines.

If so please try this:

Import-Csv -Path "<yourCSVfileName.csv>" | ForEach-Object {  
    $_.GroupOwner  
    $_.GroupName  
}  

You should see 4 lines ...

Owner1 (line 2 in your CSV)
Group1 (line 2 in your CSV)
Owner2 (line 3 in your CSV)
Group2 (line 3 in your CSV)

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten

Import-Csv -Path "c:\temp\GroupsC.csv" | ForEach-Object {
$ownerUserObj = $UserObj = Get-AzureADUser -ObjectId $.GroupOwner
$newGroup = New-AzureADGroup -DisplayName $.GroupName -SecurityEnabled $true -MailEnabled $false -MailNickName "NotSet"
Add-AzureADGroupOwner -ObjectId $newGroup.ObjectId -RefObjectId $ownerUserObj.ObjectId
}

I Used this Below cmdlet but get the same error as shared earlier :

Import-Csv -Path "C:\temp\GroupsC.csv" | ForEach-Object {
$ownerUserObj = $UserObj = Get-AzureADUser -ObjectId $.GroupOwner
$newGroup = New-AzureADGroup -DisplayName $.GroupName -SecurityEnabled $true -MailEnabled $false -MailNickName "NotSet"
Add-AzureADGroupOwner -ObjectId $newGroup.ObjectId -RefObjectId $ownerUserObj.ObjectId
}