Bulk update Azure AD from Powershell - FAILED to update

JasonG91 

Here's your script with the try...catch block removed - perhaps save it as a different name while you diagnose the root issue.

If you run this version, you should see the real error(s) being listed.

If your CSV is large, consider reducing it in size for this diagnostic-only version of the script, as there's no value in having a thousand of the same error popping up.

$CSVrecords = Import-Csv C:\Temp\Test.csv -Delimiter ","

$SkippedUsers = @()
$FailedUsers = @()


foreach ($CSVrecord in $CSVrecords) {
    $upn = $CSVrecord.UserPrincipalName
    $user = Get-AzureADUser -Filter "userPrincipalName eq '$upn'"  
    if ($user) {
        $user | Set-AzureADUser -jobTitle $CSVrecord.jobTitle -department $CSVrecord.department -officeLocation $CSVrecord.officeLocation -streetAddress $CSVrecord.streetAddress -city $CSVrecord.city -state $CSVrecord.state -postalCode $CSVrecord.postalCode -telephoneNumber $CSVrecord.telephoneNumber -mobile $CSVrecord.mobile
    }
    else {
        Write-Warning "$upn not found, skipped"
        $SkippedUsers += $upn
    }
}

Cheers,

Lain