Announcements
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
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
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.
> 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)?
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 557
Valantis 328
David_MA 264 Super User 2026 Season 1
