How to update data in azure AD from a csv file?

Question

Need to update EmployeeID, Department,City,Country,State,StreetAddress,EmployeeType,EmployeeHireDate for 400 users.

I keep seeing stuff about running Microsoft graph but I’m having issues with that

Answer 1

# Connect to AzureAD
Connect-AzureAD

# Get CSV content
$CSVrecords = Import-Csv C:\Temp\Test.csv -Delimiter ";"

# Create arrays for skipped and failed users
$SkippedUsers = @()
$FailedUsers = @()

# Loop trough CSV records
foreach ($CSVrecord in $CSVrecords) {
    $upn = $CSVrecord.UserPrincipalName
    $user = Get-AzureADUser -Filter "userPrincipalName eq '$upn'"  
    if ($user) {
        try{
        $user | Set-AzureADUser -Department $CSVrecord.Department -TelephoneNumber $CSVrecord.TelephoneNumber
        } catch {
        $FailedUsers += $upn

        Write-Warning "$upn user found, but FAILED to update."
        }
    }
    else {
        Write-Warning "$upn not found, skipped"
        $SkippedUsers += $upn
    }
}

References: [https://techcommunity.microsoft.com/t5/windows-powershell/bulk-update-azure-ad-with-user-attributes-from-csv/m-p/1374479

@Azim Iqbal : You can check and modify the above-mentioned script based on your requirement.

Answer 2

Hi Azim Iqbal ,

To see if you receive different results, please try changing this line:

$CSVrecords = Import-Csv C:\Windows\system32\TempAzureADUserAttributesNSS12.csv -Delimiter ";" 

To the following:

 $CSVrecords = Import-Csv C:\Windows\system32\TempAzureADUserAttributesNSS12.csv

Also, please try displaying your file to ensure that Windows isn't adding a double extension:

dir C:\Windows\system32\TempAzureADUserAttributesNSS12.csv 

Let me know if this helps and if you are still facing this issue. There are some troubleshooting steps for that script offered in this thread: [https://techcommunity.microsoft.com/t5/windows-powershell/bulk-update-azure-ad-with-user-attributes-from-csv/m-p/1374479

-

If the information helped you, please Accept the answer. This will help us and also improve discoverability for others in the community who might be researching similar information.