web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : lT9wgaBwjlrJIQ3kwS6ZuR
Power Automate - Using Flows
Answered

Filter Query in loop for List rows present in a table

Like (0) ShareShare
ReportReport
Posted on 7 Apr 2023 03:33:41 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 07 Apr 2023 at 05:32:10
    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,954 Super User 2025 Season 2 on 07 Apr 2023 at 04:37:21
    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 07 Apr 2023 at 04:31:13
    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,954 Super User 2025 Season 2 on 07 Apr 2023 at 04:02:45
    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 07 Apr 2023 at 03:58:06
    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,954 Super User 2025 Season 2 on 07 Apr 2023 at 03:41:38
    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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Featured topics

Restore a deleted flow
Loading complete