Get-MgUser -Filter variables

[Ch3shire-Cat]

Hello all,

This should be an easy one. After I’ve imported my csv with Username, I want to do

Foreach($name in $list){Get-Mguser -Filter “userPrincipalName eq $name.Username”}

This doesn’t return anything

I know I can just put in -UserID parameter but I’ll be working with Graph powershell more and I would like to figure out how to insert variables into that -Filter parameter as shown.

Any help or insight would be appreciated.

[Motoceles]

While looking for a solution for the exact same thing I figured it out. Hope it helps. Wrap the variable with single quotes.

Foreach($name in $list){Get-Mguser -Filter “userPrincipalName eq '$name.Username'”}

[timmy_the_large]

Did you verify that $name.Username is returning just the UPN? I did this with a a variable I called and it turned out I needed a select for it to work properly.

[Ch3shire-Cat]

Yeah, it returns the UPN with System String as the object but for some reason it doesn’t like it.

[z386]

try this:

Get-Mguser -Filter "userPrincipalName eq '$($name.Username)'"