How do I select properties with a variable in Powershell Select-Object

Question

Test 1 works as expected. Why doesn't Test 2 work the same way?

$user="bsimms"
Write-Host "test 1"
$test1out=Get-ADUser  $user -Properties * | Select-Object -Property Name, samAccountName, EmployeeID
Write-Host "test1: $test1out"
$myitems="Name, samAccountName, EmployeeID"

Write-Host "test 2"
$test2out=Get-ADUser  $user -Properties * | Select-Object -Property $myitems
Write-Host "test2: $test2out"

Output C:\>powershell .\file.ps1 
test 1 
test1: @{Name=Bob Simms; samAccountName=bsimms; EmployeeID=0123450} 
test 2 
test2: @{Name, samAccountName, EmployeeID=Microsoft.ActiveDirectory.Management.ADPropertyValueCollection}

Can you please add more context to your question? – marcogmonteiro Nov 07 '20 at 17:36 — marcogmonteiro, Nov 07 '20 at 17:36

score 0 · Accepted Answer · answered Nov 07 '20 at 17:00

0

You must define $myitems as array of property names.

PS > $myitems = @("Name", "samAccountName", "EmployeeID")
PS > Get-ADUser  $user -Properties * | Select-Object -Property $myitems

answered Nov 07 '20 at 17:00

Abdul Niyas P M

18,035
2
25
46

You don’t need @() – Doug Maurer Nov 07 '20 at 19:03

How do I select properties with a variable in Powershell Select-Object

1 Answers1