powershell - Msolservice - copy value from one attribute to another

Question

I have a large number of users in Azure where I need to copy the value in the attribute Office to the attribute State. If State contains a value and Office doesn't, State must be cleared. The two attributes must be the exact same afterwards. I have to use Powershell and MSonline/msolservice https://docs.microsoft.com/en-us/powershell/module/msonline/?view=azureadps-1.0

Any suggestions?

question from:https://stackoverflow.com/questions/65907117/msolservice-copy-value-from-one-attribute-to-another

Answer 1

You have clarified the logic.

What you need to do is to poll all users and check the two properties of Office and State.

A simple sample for your reference:

$users = Get-MsolUser

foreach($user in $users){
    if ($user.Office -ne $null -and $user.Office -ne $user.State) {
        Set-MsolUser -UserPrincipalName $user.UserPrincipalName -State $user.Office
    }
    if ($user.Office -eq $null -and $user.State -ne $null){
        Set-MsolUser -UserPrincipalName $user.UserPrincipalName -State "$null"
    }
}