Unanswered

ODATA filter and operators for multiple filters

(0) Share

Report

Posted on by Julianveda

Hi community,

I'm having trouble making work the ODATA filter with a "and" or "or" operator in the "List rows in excel". When I use a single filter (without "and" or "or") everything works smoothly. As soon as I use an operator to filtering based on two conditions I got an error (screen capture here below). I have tried all possible ways (with parenthesis, etc) but nothing seems to work.

Figure 01: ODATA filter with operator

Figure 02: Error details

I found a way around this by duplicating my flow and therefore having one flow for each filter. However, this is not ideal in the case I have to add more filters.

Figure 03: workaround (double the steps to use one filter by step)

Do you know if my ODATA filters is not working because I have some sort of version not supporting multiple filters as the error message seems to be telling me or if I am not doing things well ?

Also, would you have other proposals for working around this situation apart from the one I'm using (duplicating the steps) ?

Thank you for your help 🙂

Julian

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

v-yueyun-msft on at

Like (1)

Report

Hi , @Julianveda

Currently Excel connector does not support multiple conditions in filter query. use filter array action after List row present in a table and use multiple conditions.

@or( equals(item()?['Header'], 'Media') , equals(item()?['Header'], 'Stdev') )

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
Julianveda 26 on at

Like (0)

Report

Hi @v-yueyun-msft ,

Thank you for your answer. Unfortunately, I have also tried that and did not work. I explain here below what I get when using filter array:

This is my workflow when adding filter array:

As soon as I run this, all the data is copied from the first table to the second table and not only the array I indicated in the "Filter array". I suppose this is happening due to the dynamic value "Value" in the "apply to each" that makes reference to the result from "List rows" intead of the result from "filter array".

I tried therefore to modify this, by selecting a dynamic value that makes reference to the result from the "filter array". I have only two possibilities:

No matter if I choose Item or body, I get the same structure for the steps that follow (image below):

And when I run this, I get an error:

Am I missing something ?

Thanks,
Julian

Was this reply helpful? Yes No
Verified answer

v-yueyun-msft on at

Like (1)

Report

Thanks for your quick response! According to your screenshot , your Filter query action run successfully in your side.

You just need to loop the Body of the Filter query action.

If you want to extract the one of the field value , you can use the code in the each loop :

item()?['fieldName']

Best Regards,

Yueyun Zhang

Hi, @Julianveda

Was this reply helpful? Yes No
Julianveda 26 on at

Like (0)

Report

Thanks a lot @v-yueyun-msft 🙂

Was this reply helpful? Yes No