cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Zubayer
Helper I
Helper I

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

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 

 

Zubayer_0-1627386878865.png

 

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
AnthonyAmador
Community Support
Community Support

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. 

AnthonyAmador_0-1627401151529.png

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

AnthonyAmador_1-1627401243358.png

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

AnthonyAmador_2-1627401324815.png

  • 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.  

AnthonyAmador_3-1627401490428.png

 

The flow should look like this. 

 

AnthonyAmador_8-1627403340675.png

 

 

Hope this help you. 

Cheers. 

 

 

 

View solution in original post

4 REPLIES 4
AnthonyAmador
Community Support
Community Support

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. 

AnthonyAmador_0-1627401151529.png

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

AnthonyAmador_1-1627401243358.png

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

AnthonyAmador_2-1627401324815.png

  • 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.  

AnthonyAmador_3-1627401490428.png

 

The flow should look like this. 

 

AnthonyAmador_8-1627403340675.png

 

 

Hope this help you. 

Cheers. 

 

 

 

Zubayer
Helper I
Helper I

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

Zubayer_0-1627471709059.png

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 

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.

AnthonyAmador_0-1627567124457.png

 

I hope this helps. 

Cheers.

Zubayer
Helper I
Helper I

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

 

Thanks

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

Users online (2,484)