Answered

My flow cant read >250 rows of data on Excel, the data above 250rows will not be read

(0) Share

Report

Posted on by Deltodeus

So apparently I am working with Power Automate to automatically send email to >500 customers in the form of row using excel. For example like this.

I want to send an email to 500 customers. My email was sent with the "Expired Date" column as the trigger whether the email will be sent or not. Here I know not all my emails are sent, after I researched there are only 257 lines of data that are read by Power Automate while the email sent is only less than 20 (because the conditions are met).

What i want to know is, do you know how to make the power automate able to read all of the rows of data and it will be processed in accordance with the program, or at least i can send all the email that met the condition without any problem? thank you

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

hemrhk 361 on at

Like (1)

Report
Copy link

Link copied!

@Deltodeus
I am assuming you are using the list rows action, By default it will pull only 250 rows so you need to enable pagination.
Select the menu of that action->enable pagination->enter the threshold

-------------------------------------------------------------------------------------------------
If it solved your problem give a kudos and accept it as a solution.

Follow and Subscribe 365 Stack for more updates.

Was this reply helpful? Yes No
Deltodeus 80 on at

Like (0)

Report
Copy link

Link copied!

do you know what is the maximum threshold and the consequences for setting it to maximum?

Was this reply helpful? Yes No