I have a powershell script where I need to get some items from SharePoint online list, filtered by one value in string column, and it only works if I put value in quotes.
$Number=123 # NOT working, no values returned from SP
[string]$Number=123 # NOT working, no values returned from SP
$Number="123" # WORKING
and then
$query = "<View><Query><Where><Eq><FieldRef Name='Number'/><Value Type='Text'>$Number</Value></Eq></Where></Query></View>";
$NumberInfo = (Get-PnPListitem -List SPList -Query $query).FieldValues
Any ideas what I could be doing wrong?
Thanks