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

[mvcsharepointdev]

I have the following PnP PowerShell script, which read data from SQL Server and update SharePoint using PnP PowerShell:-

$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 will always get this error:

The specified user could not be found.
but if I type the email address manually i will get the user:

$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?

Thanks