Announcements
I desire to use a filter to find data for my schedule flow. I use a loop and List rows present in a table inside. Then, I want to put Current item in form System eq 'Current Item' in the Filter Query. But it can't work. What would i do?
Hi @dinerogs
May i know what is through you are loop, so that i can understand what is the current item actually is ?
I'm in a loop for fetching data to be used to send emails after the loop completes. So my current item is the system name, I declare an array containing the system name ["abc","def","ghi"] in initialize variable then I get the output of it and use for the apply to each.
Are you getting ant error?
Also please confirm whether you are writing filter query like below
Yes. In filter query, I have added (System eq 'Current item') and (Date eq 'formateDateTime(utcNow(), 'yyyy-MM-dd))
Multiple conditions is not supported in filter query in excel connectors.
https://powerusers.microsoft.com/t5/Building-Flows/how-to-pass-multiple-filter-condition-in-list-of-row-present-in/td-p/1506216
Hope this helps 🙂
Oh, Thank you. I appreciate the information and advice you have shared.
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.
Vish WR 862
Valantis 738
Haque 553
