cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Error in Get item Filter query

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

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,

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

View solution in original post

1 REPLY 1
Highlighted
Community Support
Community Support

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,

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

View solution in original post

Helpful resources

Announcements
Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Users online (4,805)