Answered

Filter Query with two conditions, using AND

Like (1) Share

Report

Posted on 20 Jan 2022 14:11:51 by MCeron98

Hi! I have a flow in which I want to compare the Conversation ID and the Arrived Time of an email using the filter query inside the list rows action. However seems that the "and" is not recognized. Is it that I am having a sintax error?

Invalid filter clause: unsupported operation. Only single 'eq', 'ne', 'contains', 'startswith' or 'endswith' is currently supported.

Does somebody ever experienced a similar situation?

Thanks a lot for your help!

I have the same question (0)

All responses (2)

Answers (1)

A1234567 16 on 08 Sep 2022 at 13:19:58

Like (0)

Report

Re: Filter Query with two conditions, using AND

As many real-world cases require filters with more than just one condition, it would be great to actually fix this issue/limitation. The workaround isn't good as it needs to load all the unnecessary data first and only then apply required filters.

Was this reply helpful? Yes No
Verified answer

v-jefferni on 24 Jan 2022 at 05:58:48

Like (0)

Report

Re: Filter Query with two conditions, using AND

Hi @MCeron98 ,

We can't add multiple filters in Excel Filter Query. Please try and use one condition in the filter query then add a filter array operation into your flow for the other condition.

Hope this helps.

Best regards,

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

Was this reply helpful? Yes No