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?
Oh, Thank you. I appreciate the information and advice you have shared.
Hi @dinerogs
Multiple conditions is not supported in filter query in excel connectors.
Hope this helps 🙂
Yes. In filter query, I have added (System eq 'Current item') and (Date eq 'formateDateTime(utcNow(), 'yyyy-MM-dd))
Hi @dinerogs
Are you getting ant error?
Also please confirm whether you are writing filter query like below
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.
Hi @dinerogs
May i know what is through you are loop, so that i can understand what is the current item actually is ?
WarrenBelz
146,524
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,906
Most Valuable Professional