Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Answered

Filter Query in loop for List rows present in a table

(0) ShareShare
ReportReport
Posted on by 20

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?

  • dinerogs Profile Picture
    20 on at
    Re: Filter Query in loop for List rows present in a table

    Oh, Thank you. I appreciate the information and advice you have shared.

  • Verified answer
    Nived_Nambiar Profile Picture
    17,497 Super User 2025 Season 1 on at
    Re: Filter Query in loop for List rows present in a table

    Hi @dinerogs 

     

    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 🙂

     

  • dinerogs Profile Picture
    20 on at
    Re: Filter Query in loop for List rows present in a table

    Yes. In filter query, I have added (System eq 'Current item') and (Date eq 'formateDateTime(utcNow(), 'yyyy-MM-dd))

  • Nived_Nambiar Profile Picture
    17,497 Super User 2025 Season 1 on at
    Re: Filter Query in loop for List rows present in a table

    Hi @dinerogs 

     

    Are you getting ant error?

     

    Also please confirm whether you are writing filter query like below

     

    Nived_Nambiar_0-1680840153341.png

     

     

  • dinerogs Profile Picture
    20 on at
    Re: Filter Query in loop for List rows present in a table

    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.

  • Nived_Nambiar Profile Picture
    17,497 Super User 2025 Season 1 on at
    Re: Filter Query in loop for List rows present in a table

    Hi @dinerogs 

     

    May i know what is through you are loop, so that i can understand what is the current item actually is ?

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.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,524 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,906 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow