Updating 1300 rows in Excel using Power Automate

[amsrivas]

Hi Folks!!

I need to update 1330 rows of Excel B Worksheet Sheet from Excel A worksheet, but i am not able to update the records after record 256.

How to update all the records using Power Automate, Please suggest!!

Thanks

Amit Srivastava

[Sonapsen]

Greetings,

It is by default Microsoft Flow sets the limit to 256 rows. Try to increase the limit by:

[1] Navigate to Settings on the Excel step
[2] Enable Pagination
[3] Set the Threshold above 256 i.e. 1,300.