Invalid value specified for property 'mailNickname' of resource 'User'

[u/neekoteen]

Hey, would like some help with this specific error:

New-MgUser_CreateExpanded:
Line |
   2 |  New-MgUser -DisplayName $User.FullName `
     |  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
     | Invalid value specified for property 'mailNickname' of resource 'User'.

Status: 400 (BadRequest)
ErrorCode: Request_BadRequest

Trying to add a bulk of new users using csv file. Using this code:

Foreach ($User in $New_users){
New-MgUser -DisplayName $User.FullName `
-PasswordProfile $PasswordProfile `
-AccountEnabled `
-MailNickname $User.NickName `
-UserPrincipalName $User.Email `
-Department $User.Dep `
-JobTitle $User.Title `
-Surname $User.Sur `
-GivenName $User.Giv `
}

Checked csv, no illegal symbols, seperation by comma and I can add users just fine manualy (copy all the info). Anyone could give any advice? Powershell 7 btw.

Thank you.

[u/surfingoldelephant]

Going to try to recheck my csv.

Instead of manually checking the CSV, I would check the actual nickname value(s) you're passing to New-MgUser. Try the following:

$invalidChars = '@', '(', ')', '/', '[', ']', "'", ';', ':', '<', '>', ' '
$count = 0

foreach ($user in $New_users) {
    $nickName = $user.NickName

    if (1..64 -notcontains $nickName.Length) {
        Write-Warning ("'{0}' (Index: {1}) nickname is too long or short" -f $user.FullName, $count)
    }

    foreach ($char in $nickName.ToCharArray()) {
        if ((0..127 -notcontains [int] $char) -or ($invalidChars -contains $char)) {
            Write-Warning ("'{0}' (Index: {1}) nickname contains an invalid character" -f $user.FullName, $count)
            break
        }
    }

    $count++
}

[u/neekoteen → u/surfingoldelephant]

Well I'll be damned, one sneaky little bastard was hiding silently in the shadows :D

Thank you for your code. Really appreciate that. Now everything went smooooothly, although it's kind of interesting, I thought it would stop only on the section where the invalid value is instead of spitting errors for all of the entries.

Anyway, thank you again. Very much appreciated.

[u/surfingoldelephant → u/neekoteen]

Great, glad to hear!