Error in Get item Filter query

(0) Share

Report

Posted on by harshadb

We are using AND & OR operator in filter query on Getitem (sharepoint) card but getting below error

Filter query syntax : (Status eq 'A' AND (DateOfJoin eq '2020-06-19' OR substringof('07-20',DateOfBirth))

Error: The expression "(Status eq 'A' AND (DateOfJoin eq '2020-06-19' OR substringof('07-20',DateOfBirth))" is not valid. Creating query failed. clientRequestId: dd21470d-849f-4954-92cf-8501cac0c273 serviceRequestId: dd21470d-849f-4954-92cf-8501cac0c27

How we can achieve using AND & OR operator in single query

All responses (1)

Answers (1)

Verified answer

v-bacao-msft on at

Like (0)

Report

Re: Error in Get item Filter query

Hi @harshadb ,

First, make sure that each individual filter is valid. You could configure these filters separately in Filter Query and test them separately.

It should be noted that the calculated column and Choice filed cannot be configured in Filter Query.

Best Regards,