Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Answered

List rows in a table filter query failing

(0) ShareShare
ReportReport
Posted on by

I am using list rows in a table action to get a row using filter query.

My excel contains more than 10000 rows.

 

I am using dynamic file path in this.

I have followed this article to get this workaround using microsoft graph : http://johnliu.net/blog/2019/5/workarounds-needed-to-use-the-excel-connector-in-microsoft-flow

 

Here is my list rows action : 

Capture.JPG 

 

When I run this flow, it fails for the first time saying "Resource not found". But when flow is resubmitted it works perfectly fine and returns the row. After that flow never fails.

 

Now again if I change the file (file path is taken dynamically) it fails in the first run and works fine with second run onwards.

 

What am I doing wrong here?

Any help is appreciated.

 

P.S : If filter query is not applied then flow runs fine everytime. I believe it's an error with filter query.

Also, I can not use "Get a row" action due to some other limitations. 

  • Community Power Platform Member Profile Picture
    on at
    Re: List rows in a table filter query failing

    Hi @shu ,

     

    Yes ID is one column in excel table. This workaround does work. But, it's a strange bug in "List rows in a table" action.

     

    Though this only works when both "List rows.." pagination is enabled and threshold is set to 5000. Otherwise same issue appears.

     

    Thank you.

  • Verified answer
    Jessie Chen Profile Picture
    on at
    Re: List rows in a table filter query failing

    @Anonymous  Is 'ID' one column in the excel table? I think it fails for the first time because it didn't get the rows correctly. As a workaround , could you please add the same action again before this 'List rows present in a table' but without filter query?

     

    Best Regards,

     

    Jessie Chen

     

    Support Engineer

    Asia Dynamics 365 Support

    Customer Services and Support

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

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,702 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,017 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow