The expression is not valid. Creating query failed.

(0) Share

Report

Posted on by Davinci

Hi all

I am trying to create a flow that will read and excel file and update a SharePoint list if there are new items.

Here is the error message I am getting

The expression "Program Name eq 'Axo'" is not valid. Creating query failed.
clientRequestId: 080a435d-57b9-4db1-aabb-6f38d43968ee
serviceRequestId: 080a435d-57b9-4db1-aabb-6f38d43968ee

Raw Inputs

{
 "host": {
 "connectionReferenceName": "shared_sharepointonline",
 "operationId": "GetItems"
 },
 "parameters": {
 "dataset": "https://generic.sharepoint.com/sites/testsite",
 "table": "f3ad2274-cee3-40f3-b82e-8ea48b5af58a",
 "$filter": "Program Name eq 'Axo'",
 "$top": 1
 }
}

Filter Query

filter query.JPG

Condition

Excel File

SharePoint

test

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

v-yiwenxie-msft Microsoft Employee on at

Like (0)

Report

Hi @Davinci

Since Filter Query has many limitations when using in excel or sharepoint, you can try to use ‘Filter array’ with less limitations to get the outputs you want.

If the problem still exists, please feel free to let me know.

Best Regards,
Community Support Team _ Kira Xie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

G'Day

I had this issue too - found from inspecting the raw outputs & inputs of property filters that you can't use a space in the field name - replace spaces with _x0020_

e.g. Trebuchet_x0020_ID eq '1024' where the field Trebuchet ID is a text string. Different for number fields.

Was this reply helpful? Yes No
Venomtver 75 on at

Like (0)

Report

Replacing space is not always working.
I also tried to apply Filter array, but didn't find fast solution with that.
Instead, I found out, that if you switch your field to advanced mode, you will see how your field should be written in filter query.
Add value in 'quotes' to your query to make it work.

Was this reply helpful? Yes No
Barath_Kumar_G 2 on at

Like (0)

Report

Hello ,
Above filter array also not working

Was this reply helpful? Yes No
rekha97jr 34 on at

Like (0)

Report

Hi @v-yiwenxie-msft , @Barath_Kumar_G , @Davinci , @Venomtver I have a condition for 2 of my fields in sharepoint, which says "Evaluate to TRUE if From date and To date are having values. evaluate to false otherwise". But i dont knw why it always evaluates to TRUE when tested.

can you please help.

Capture1.PNG

Capture.PNG

Was this reply helpful? Yes No