cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

List rows in a table filter query failing

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. 

1 ACCEPTED SOLUTION

Accepted Solutions
shu
Community Support
Community Support

@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

View solution in original post

2 REPLIES 2
shu
Community Support
Community Support

@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

Anonymous
Not applicable

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.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (4,158)