How can I pass parameter to (Get-PnPUser | ? Email -eq ($SPUserEmail));

Question

I have the following PnP PowerShell script:

$conn = New-Object System.Data.SqlClient.SqlConnection("Data Source=$DBServer;Integrated Security=True;Initial Catalog=$DBName")                        
$conn.Open();                        
$query = $Query                        
$dap = new-object System.Data.SqlClient.SqlDataAdapter($query,$conn);                        
$dt = new-object System.Data.DataTable;                        
$null = $dap.Fill($dt)  
      foreach($r in $dt.Rows )   {                         
$SPUserEmail = $r["email_address"];
$SPuser = (Get-PnPUser | ? Email -eq ($SPUserEmail));}

but I always get this error:

The specified user  could not be found.

but if I type the email address manually I get the user details:

$SPuser = (Get-PnPUser | ? Email -eq [email protected]);

although when I do Write-Host $SPUserEmail I will get [email protected]

So what could be the reason?

Answer 1

It's because $SPUserEmail holds a object, and the email is a property. Get-PnpUser expects a string value.

PropertyName is the property name found in the object.

To get only the value out of the object, either select it when setting the variable:

$SPUserEmail = $r["email_address"] | Select-Object PropertyName -ExpandProperty PropertyName 

Or by expanding the property value you need:

(Get-PnPUser | Where-Object Email -eq ($SPUserEmail.PropertyName))