Notifications
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Michael E. Gernaey 501 Super User 2025 Season 2
Tomac 323 Moderator
abm abm 237 Most Valuable Professional
