Answered

How to get more than 256 rows from excel using Pagination in each Iteration

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Mates,

It seems like limitation on getting rows from Excel, i can not get more than 256 rows,

yes i tried to set 1000 at Maximum Get Count but still i can get only 256 items from excel, by any chance can we get/set with other options ..?

1. By any chance can we get 1000 or 500 at a time with help of Pagination option ...? where each time it can retrieve specified or 256 items in each loop, but it has to loop all the items and update.

yes i have googled but no luck.

Your help would be really appreciated.

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi On top of that i turned on Pagination, updated with item threshold 5000,
from excel no issue looping items,
but during writing/inserting it throws error like "Flow run timed out. Please try again" at 1060 item means its updated till 1059 items around.
How can get rid out of this time out issue during inserting.

Was this reply helpful? Yes No
MJain 2,450 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Can you please share your flow screenshot. In Apply to Each you can set the concurrency to perform operations much faster.

Thanks

Was this reply helpful? Yes No
Verified answer

v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

"Flow run timed out. Please try again" is temporarily alert, if you negative to Flow details then click Flow runs, it will disappear.

There is no time limit when the Apply to each action runs, I tested on my side to insert 2400 rows into an Excel table and successful.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No