Filter Query excel multiple conditions

Like (0) Share

Report

Posted on 19 Jun 2022 11:25:55 by Mischa2710

105

Hello together,

is there a way to filter not only one condition in Excel (oData)? I would like to add the filter in Filter array Test ..., too.

Thanks in advance

Michael

All responses (4)

Answers (0)

Ravabelli 10 on 04 Jan 2024 at 08:51:40

Like (2)

Report

Re: Filter Query excel multiple conditions

It was technically true 15 months ago when I wrote this. See Excel Online (Business) - Connectors | Microsoft Learn. Got around it with a subsequent filter array on the results.
torevor 15 on 03 Jan 2024 at 21:28:49

Like (0)

Report

Re: Filter Query excel multiple conditions

> Unfortunately the power automate excel query connector only supports one odata condition.

Is this technically true, and has Microsoft acknowledged this in documentation anywhere (do they even mention it one way or the other in documentation)?
Ravabelli 10 on 18 Oct 2022 at 11:14:53

Like (1)

Report

Re: Filter Query excel multiple conditions

Unfortunately the power automate excel query connector only supports one odata condition. Until that changes You'll have to work around this by adding a column in your spreadsheet that is a concatenation of the criteria you want to filter and use that where possible. EG filter on a YYMM column rather than YY and MM.
MarconettiMarco 3,812 Super User 2024 Season 1 on 22 Jun 2022 at 07:20:46

Like (0)

Report

Re: Filter Query excel multiple conditions

Hello @Mischa2710 ,
in the Filter Query you can add some condition in "and" or "or".
Please refer to the following doc: https://diyd365.com/2019/11/20/every-power-automate-ms-flow-filter-query-you-ever-wanted-to-know-as-a-functional-consultant/

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

BR,
Marco