I need PowerShell script to update user's office location PowerShell script to update bulk user's office location in azure AD with csv file in azure AD with csv file

Question

I need a PowerShell script to update the user's Office Location attribute Azure AD through a CSV file in bulk.

Thank you!

Mutaz

Answer 1

Hi @Mutaz Abdelmajeed ,

if your csv looks like this (for example Sample7users.csv):

CSVfileCopy

upn,office
"******@test.net","Home Office"
"******@test.net","Room 234"

this PowerShell script should work (tested):

Import-Csv ".\Sample7users.csv" -Delimiter "," -Encoding UTF8 | ForEach-Object {
    $user = Get-AzureADUser -Filter "userPrincipalName eq '$($_.upn)'"
    Set-AzureADUser -ObjectId $user.ObjectID -PhysicalDeliveryOfficeName "$($_.office)"
}

---

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

Regards

Andreas Baumgarten