cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Zubayer
Frequent Visitor

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
Microsoft
Microsoft

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
Microsoft
Microsoft

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

Zubayer
Frequent Visitor

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
Frequent Visitor

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

 

Thanks

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (1,437)