cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mariamingallon
Frequent Visitor

Excel connector issue with Pagination and Threshold

I use pagination and threshold for the 'List rows present in table' (Excel for Business) node in power automate. I had used the following settings: 

  • pagination: 'On'
  • threshold: 100000

 

The flow was working fine until today I tried doing an edit on a subsequent node which then triggered the following error message on the Excel node referred to above:

 

"The pagination policy of workflow run action 'List_rows_present_in_a_table_2' of type 'ApiConnection' at line '1' and column '49100' is not valid. The value specified for property 'minimumItemsCount' exceeds the maximum allowed. Actual: '100000'. Maximum: '5000'."
 
See snapshots for more info. 
 
It works if I use pagination but limit the threshold to '5000'. It is a fix that will buy me some time but at some point, I will need more than 5000 entries as the register number of rows grows. Is there any reason why the threshold has now been limited to '5000' instead of '100000'? It was all working fine for a few months and just a bit puzzled the connector is now giving these issues.
 
Thanks in advance for your help!
 
Best,
Maria
 
 

Capture.JPG

 
2 REPLIES 2
Mischa2710
Helper III
Helper III

Hello, I have exactly the same problem. Could anybody help you?

arungambhir
New Member

We faced the same issue, we create a replica of that flow & deleted the original one. And it worked.

 

-Arun

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors
Users online (3,079)