Answered

Loop limit at 257?

(0) Share

Report

Posted on by Minwahsin_Tech

Hello,

I'm new to using Power Automate in our business process. I use it to convert Excel documents into CSV documents. Generally, everything works, but when I have a document with a lot of lines, the conversion process stops after 257 lines.

Is it possible that Power Automate limits the number of loops?

Thanks for any answers you can provide.

Capture d’écran, le 2024-03-06 à 22.09.03.png

Capture d’écran, le 2024-03-06 à 22.05.36.png

Capture d’écran, le 2024-03-06 à 22.05.44.png

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Minwahsin_Tech ，

Please turn on Pagination and set the threshold to 5000 in ’List rows present in a table‘.

Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
Minwahsin_Tech 6 on at

Like (0)

Report
Copy link

Link copied!

Hello, Thank you for your reply. I don't know why, but I can't see the parameters when I press the three dots. Do you know why?

Was this reply helpful? Yes No
Tristan_D 405 on at

Like (1)

Report
Copy link

Link copied!

Hi @Minwahsin_Tech ,

You are on the new visual on power automate, if you click on "Settings" , you should see more options 😉.

T

1 people found this reply helpful.

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Minwahsin_Tech ,

Yes, @Tristan_D is right, you can click the settings on the right side of the parameters to see the Pagination settings.

Or you can switch to classic designer.

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No