Hi,
I am using a filter query step in a flow to get a specific record from a Products SP list using a serial number field. The serial number field is a single line text field.
The issue is that if I have a record of a product with the serial number beginning with 0 then filter query step fails with this error message - "The expression "SerialNumber eq 06201200" is not valid. Creating query failed." but if I add a 1 at the beginning of the serial number and do the same then it works.
Is there a reason why this fails with a leading 0?
Dhiran