I want to create a flow to send bulk email but it has to send 30 emails per sec with 1 min delay.

[Zubayer]

I have an excel online file with a full list of 4236 users' email addresses. Now I want to send emails to those users from a shared mailbox. I created that list into a table format so that I can get the email addresses as dynamic values using "list rows present in a table" but I want to get/send only 30 emails per session and give 1 min delay and get/send next 31-60 serial emails again with 1 min delay and again 61-90 serial emails. 

currently, I am using an easy but time-consuming method by creating multiple tables and 

but I need help to create a dynamic flow that will only send email 30 emails after that with a 1 min delay. 

[AnthonyAmador · Accepted solution]

Hi @Zubayer 

I think a better solution for your problem using just a list with all emails should look like this. 

• Before the "apply to each", declare a variable, this variable will be our count to know how many emails sent before make a delay. 

• Then we initialize the "apply to each" and send the email to every email address in the list you select. 

• Next, we increase our variable by 1 in the apply to each, this means that we have sent 1 email. 

• The next step its to declare a condition, this condition star only if our variable reach 30. If yes it suppose to delay the apply to each 1 minute and set the variable to 0, to start all the process again.  

The flow should look like this. 

Hope this help you. 

Cheers. 

[Zubayer]

Thanks, @AnthonyAmador for your help and it works partially. 

As you can see in the picture it only sends 256 emails every time I run it. Can you please help me out with how can I overcome this As I want to send almost 8000-9000 emails 

[AnthonyAmador]

I think it is happening because the default limit is 256 rows, try doing this. 

• Go to "List rows present in table" action.
• Select the options elipses ("...")
• Select 'Settings'.
• Enable Pagination.
• Set an appropriate row limit.

I hope this helps. 

Cheers.

[Zubayer]

Thanks brother IT worked with my test with 555 emails. hopefully, its will work with 8000 emails.

Thanks