web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / I want to create a flo...
Power Automate
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 74

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. 

Categories:
I have the same question (0)
  • Verified answer
    AnthonyAmador Profile Picture
    2,553 Moderator on at
    Re: I want to create a flow to send bulk email but it has to send 30 emails per sec with 1 min delay.

    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 Profile Picture
    74 on at
    Re: I want to create a flow to send bulk email but it has to send 30 emails per sec with 1 min delay.

    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 

  • AnthonyAmador Profile Picture
    2,553 Moderator on at
    Re: I want to create a flow to send bulk email but it has to send 30 emails per sec with 1 min delay.

    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 Profile Picture
    74 on at
    Re: I want to create a flow to send bulk email but it has to send 30 emails per sec with 1 min delay.

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

     

    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard