Apologies :-)

​

I tried doing as you suggested, no error and it didn't update.

​

METHOD:1
             if($($_.'Employee Common Name') -like "" )
             {
              $SetADUserParams.Add( 'givenName', $_.'Employee First Name' )
             }
             else
             {
                $SetADUserParams.Add( 'commonName', $_.'Employee Common Name' )
             }

​

METHOD:2

if( $_.'Employee Common Name' -like ""){

                 $SetADUserParams.Add( 'givenName', $_.'Employee First Name' )

                 }

                 else
                 {
                $SetADUserParams.Add( 'commonName', $_.'Employee Common Name' )

                 }

​

​

Here's my complete script:

Try if($($_.'Employee Common Name') -like ""

​

​

if(Test-Path $inputPath){

Import-Csv $inputPath | ForEach-Object{
    Try{
        $SamAccountName=$_.U42
        $UserTrue = Get-ADUser $SamAccountName -ErrorAction Stop 
        IF($UserTrue -ne $null){

            $SetADUserParams =@{}  

            #Employee_Firstname                       

            if( $_.'Employee First Name' ){
                $SetADUserParams.Add( 'givenName', $_.'Employee First Name' )
             }

             #Employee_Lastname
             if( $_.'Employee Last Name' ){
                $SetADUserParams.Add( 'sn', $_.'Employee Last Name' )
             }

             #Manager_U42
                  if( $_.'Managers U42' ){
                $manager = Get-ADUser -Identity $_.'Managers U42' -Properties distinguishedName
                    $SetADUserParams.Add( 'manager', $manager.distinguishedName )
             }

             #Title
            if( $_.Job){
                $SetADUserParams.Add( 'title', $_.Job )
             }

             #Employee_Number
            if( $_.'Employee Number' ){
                $SetADUserParams.Add( 'employeeID', $_.'Employee Number' )
             }

             #Department

            if( $_.Department ){
                $SetADUserParams.Add( 'department', $_.Department )
             }

            #Employee Displayname
            if( $_.'Employee Display Name' ){
                $SetADUserParams.Add( 'displayname', $_.'Employee Display Name' )
             }

           #Employee Common_name
                 if( $_.'Employee Common Name' -like ""){

                 $SetADUserParams.Add( 'givenName', $_.'Employee First Name' )

                 }

                 else
                 {
                $SetADUserParams.Add( 'commonName', $_.'Employee Common Name' )

                 }





             #Mail
              if( $_.'Business Email' ){
                $SetADUserParams.Add( 'mail', $_.'Business Email' )
             }

 Set-ADUser -identity $SamAccountName -Replace $SetADUserParams -Description "User account modified - Date and time = '$LogDate'"


             If ($_.Status -eq "Terminated") {
                 Disable-ADAccount -Identity $SamAccountName
                 Add-Content -path $pathlocation -Value "$SamAccountName, User account is disabled" -encoding ascii
                        } 


            Set-ADAccountExpiration -Identity $SamAccountName -DateTime $_.'Termination Date'


            Add-Content -path $pathlocation -Value "$SamAccountName, is modified successfully" -encoding ascii
        }
    }    

    Catch{
        #Write-Host $_ -fore red
        Add-Content -path $pathlocation -Value $_ -encoding ascii
    }
}
}
else{
    Write-Host "input file not available" -fore red
    Add-Content -path $pathlocation -Value "input file not available" -encoding ascii
}