The expression is not valid. Creating query failed.

Like (0) Share

Report

Posted on 8 Mar 2021 03:49:32 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

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

v-yiwenxie-msft Microsoft Employee on 08 Mar 2021 at 05:59:08

Like (0)

Report

Re: The expression is not valid. Creating query failed.

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 23 Feb 2022 at 01:00:19

Like (1)

Report

Re: The expression is not valid. Creating query failed.

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 06 May 2022 at 13:50:04

Like (0)

Report

Re: The expression is not valid. Creating query failed.

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 02 Jun 2022 at 10:59:05

Like (0)

Report

Re: The expression is not valid. Creating query failed.

Hello ,
Above filter array also not working

Was this reply helpful? Yes No
rekha97jr 34 on 13 Apr 2023 at 04:38:15

Like (0)

Report

Re: The expression is not valid. Creating query failed.

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