In your first example, the only place that has an underbar after the "$" is in the "-Title $<underbar>.Title" parameter. All the other parameter values use only "$.valuename" where they should use "$<underbar>.valuename". However that may be due to the way Microsoft's Q&A editor works! Try using the "Code Sample" icon in the formatting bar when posting code. It's not perfect, but it does eliminate a lot of problems posting code.

Also, in the first example's "Get-ADUser" you're using the "name" value from the CSV in the -Filter. If the filter fails to find that value the result is $null -- the cmdlet doesn't throw an exception. Remove the filer and use the -Identity parameter and the samaccountname from the CSV as you did in the second example.

You also don't mention if all of your user accounts are in the same domain. If you have a multi-domain forest you'll either have to use a distinguished name or search a Global Catalog and specify the root of the forest as the -SearchBase parameter value.

Since you don't mention what the problem is (except to say "none of them worked") it's not possible to tell you what to fix. But at the least, I'd start by verifying that the sAMAccountName values in the CSV don't have any trailing spaces.

I don't recall if the properties your populating in the $props hash with $null values will work if the Set-ADUser cmdlet's parameter specifies it accepts a string type. You may want to construct the $props hash by doing something like this "if ($user.city){$props.City = $user.City}" and simply omit the parameter if it isn't present in the CSV.

Thank you all for the answers.

Error from first script:

Get-ADUser : Cannot process argument because the value of argument "path" is not valid. Change the value of the "path" argument and run the operation
again.
At line:6 char:1
+ Get-ADUser -filter {name -eq $.name}|Set-ADUSer -MobilePhone $.Mobile ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [Get-ADUser], PSArgumentException
+ FullyQualifiedErrorId : ActiveDirectoryCmdlet:System.Management.Automation.PSArgumentException,Microsoft.ActiveDirectory.Management.Commands.Get
ADUser

Get-ADUser : Cannot process argument because the value of argument "path" is not valid. Change the value of the "path" argument and run the operation
again.
At line:6 char:1
+ Get-ADUser -filter {name -eq $.name}|Set-ADUSer -MobilePhone $.Mobile ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [Get-ADUser], PSArgumentException
+ FullyQualifiedErrorId : ActiveDirectoryCmdlet:System.Management.Automation.PSArgumentException,Microsoft.ActiveDirectory.Management.Commands.Get
ADUser

This is the error when I run the second script:

Set-ADUser : Cannot validate argument on parameter 'Identity'. The argument is null. Provide a valid value for the argument, and then try running the
command again.
At line:17 char:12
+ set-aduser @props
+ ~~~~~~
+ CategoryInfo : InvalidData: (:) [Set-ADUser], ParameterBindingValidationException
+ FullyQualifiedErrorId : ParameterArgumentValidationError,Microsoft.ActiveDirectory.Management.Commands.SetADUser

Set-ADUser : Cannot validate argument on parameter 'Identity'. The argument is null. Provide a valid value for the argument, and then try running the
command again.
At line:17 char:12
+ set-aduser @props
+ ~~~~~~
+ CategoryInfo : InvalidData: (:) [Set-ADUser], ParameterBindingValidationException
+ FullyQualifiedErrorId : ParameterArgumentValidationError,Microsoft.ActiveDirectory.Management.Commands.SetADUser

Hi,

In the first script it should be $_.name, not $.name . See if this works

 $USERS|Foreach{
 $name = $_.name
 Get-ADUser -filter {name -eq $name} |Set-ADUSer -MobilePhone $_.MobilePhone -StreetAddress $_.StreetAddress -City $_.City -Title $_.Title}

The second error indicates there's no cloumn of the name "samaccountname" in your csv file. In the image I can only see ”SamAccou“ in cloumn R. Check if there is a trailing space as Rich suggested above.

Best Regards，
Ian Xue
============================================
If the Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Guys, I found other script and made some adjusts, but, I receive the error below:

Get-ADUser : Error parsing query: 'userPrincipalName eq 'vruiz'' Error Message: 'syntax error' at position: '19'.
At line:13 char:13
+ $user = Get-ADUser -Filter "userPrincipalName eq '$upn'"
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : ParserError: (:) [Get-ADUser], ADFilterParsingException
+ FullyQualifiedErrorId : ActiveDirectoryCmdlet:Microsoft.ActiveDirectory.Management.ADFilterParsingException,Microsoft.ActiveDirectory.Management.Commands.GetADUser

Script

Get CSV content

$CSVrecords = Import-Csv "C:\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-ADUser -Filter "userPrincipalName eq '$upn'"
if ($user) {
try{
$user | Set-ADUser -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
}

Try this version of that script. It corrects the comparison operator in the -Filter parameter and adds the necessary "-ErrorAction STOP" to the Set-ADUser cmdlet. Without the ErrorAction the Set-ADUser won't throw a non-terminating exception and the Catch block will never be run.

 #Get CSV content
 $CSVrecords = Import-Csv "C:\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-ADUser -Filter "userPrincipalName -eq '$upn'"
         if ($user) {
                 try {
                         $user | Set-ADUser -Department $CSVrecord.Department -TelephoneNumber $CSVrecord.TelephoneNumber -ErrorAction STOP
                 }
                 catch {
                         $FailedUsers += $upn
                         Write-Warning "$upn user found, but FAILED to update."
                 }
         }
         else {
                 Write-Warning "$upn not found, skipped"
                 $SkippedUsers += $upn
         }

Rich, after I posted that I already tried -eq.

I received this:

WARNING: USER1 not found, skipped
WARNING: USER2 not found, skipped

This is my CSV, if I open with notepad, its normal and delimited with ; and no spaces..

Damn :(

Now I can find the users, but failed to Update.

I made some changes after Set-ADUser parameter and changed to JobTitle, but no success.

Import-Module ActiveDirectory

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

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

foreach ($CSVrecord in $CSVrecords) {
$upn = $CSVrecord.UserPrincipalName
$user = Get-ADUser -Identity $upn
if ($user) {
try {
$user | Set-ADUser -JobTitle $CSVrecord.Jobtitle -ErrorAction STOP
}
catch {
$FailedUsers += $upn
Write-Warning "$upn user found, but FAILED to update."
}
}
else {
Write-Warning "$upn not found, skipped"
$SkippedUsers += $upn
}
}

WARNING: user1user found, but FAILED to update.
WARNING: user2 user found, but FAILED to update.
WARNING: user3 user found, but FAILED to update.
WARNING: user4 user found, but FAILED to update.

Without meaning to be insulting, I think you'd benefit from reading this: Windows-PowerShell-4

@RichMatheisen-8856 I saw this post, thank you for the reading tip! You can download the book certainly worth while!