Let's POWER Automate

From no-code to low-code

Menu
  • Expressions
  • Filters
  • General
  • Triggers
  • Application specific solutions
    • Dataverse
    • Excel
    • Forms
    • Planner
    • Outlook
    • SharePoint
    • Teams
  • Resources
  • Get help with flow
Menu

How to send an email sequence using Power Automate flow

Posted on August 14, 2022August 14, 2022 by Tom

“I’d like to send a sequence of 5 emails to users, one email every 2nd day, can I use Power Automate to do it for me?”


Doing tasks manually requires more time on your side with every new input. If you’re for example sending emails, each new contact means another email in your queue. The more contacts you have, the more time you’ll spend processing them, and the higher the chance of making a mistake or forgetting somebody.

That’s the situation where you should consider automation. Instead of manually preparing emails and sending them, you might delegate the work to a Power Automate flow. If there’s a new contact, send him automatically a whole email sequence – every 2nd day a new email. And this post will show you how to do that.

Create a SharePoint list to keep the information

Before you start with the flow, you’ll need a place to store the required information, e.g. a SharePoint list. It needs at least 3 columns – the email address (Title), date of the last sent email (date), and the sequence number of the last email (single line of text).

The list will serve as an evidence of each contact and its status. Once you add a new contact to the list, the whole sequence will start.

Send the first email

Each sequence will start with a creation of a new entry in the SharePoint list. Start from the trigger ‘When a new item is created’ (without modified!) and add the ‘Send an email’ action with the first email. Finish the flow by updating the item with today’s date and the number 1 – the first email was sent on the creation date.

Send the following emails in the sequence

You have the flow that’ll send the first email, now you can build the second flow to send the rest of the sequence. Since it should send an email every 2nd day, the principle will be similar to a reminder flow. Start with the ‘Recurrence’ trigger that’ll run every day, and search for items with the ‘LastEmailSent’ date two days ago AND with the ‘LastEmailSequenceNumber’ not equal to the the last email. If there’re 5 emails in the sequence, ignore the items with the number 5 – that sequence is finished.

LastEmailSent eq '@{addDays(utcNow(),-2,'yyyy-MM-dd')}' and LastEmailSequenceNumber ne 5
Power Automate email sequence

The ‘Get items’ will return all the items from the SharePoint list that are ready for the next email.

Add a ‘Switch’ action to decide what email it should send next based on the sequence number. It’ll add ‘Apply to each’ automatically which is fine, you want to process all the items one by one.

Convert the ‘LastEmailSequenceNumber’ into a number using the int(…) expression to avoid errors.

int(items('Apply_to_each')?['LastEmailSequenceNumber'])

Create a new case for each email in your sequence and add the ‘Send an email’ action inside. If the current number is 1, you want to send the 2nd email. If the number is 2, send the 3rd email and so on.

Power Automate email sequence

The last step is to update the new information to the item – set the date of the last email to ‘today’ and increment the email sequence number by 1.

add(int(items('Apply_to_each')?['LastEmailSequenceNumber']),1)
Power Automate email sequence

That’s it. The flow will run every day, check for the addresses ready for the next email, send them the corresponding email, and update the values for the next runs.

Summary

The solution to send an email sequence using Power Automate has three components – 2 flows and 1 SharePoint list. With the 3 pieces of information in the SharePoint list you can make the flow quite simple – just filter the relevant items, send the email, and update the items for the next flow run.


Do you struggle with the various expressions, conditions, filters, or HTTP requests available in Power Automate?

I send one email per week with a summary of the new solutions, designed to help even non IT people to automate some of their repetitive tasks.

All subscribers have also access to resources like a SharePoint Filter Query cheat sheet or Date expressions cheat sheet.

Zero spam, unsubscribe anytime.

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Do you know what to do, but not how to do it?

Get The Ultimate Power Automate expressions cheat sheet and translate your thoughts into flows with ease!


NEW! Master the HTTP requests to SharePoint with a new cheat sheet!

Do you struggle with the various expressions, conditions, filters, or HTTP requests available in Power Automate?

I send one email per week with a summary of the new solutions, designed to help even non IT people to automate some of their repetitive tasks.

All subscribers have also access to resources like a SharePoint Filter Query cheat sheet or Date expressions cheat sheet.

Zero spam, unsubscribe anytime.

Hello and welcome!

My name is Tom and I'm a business process automation consultant and Microsoft MVP living in the Czech Republic. I’ve been working with Microsoft technologies for almost 10 years, currently using mainly Power Automate, SharePoint, Teams, and the other M365 tools.

I believe that everyone can automate part of their work with the Power Automate platform. You can achieve a lot by "clicking" the flows in the designer, but you can achieve much more if you add a bit of coding knowledge. And that's what this blog is about.

To make the step from no-code Power Automate flows to low-code flows: using basic coding knowledge to build more complex yet more efficient flows to automate more of your daily tasks.

  • Use Power Automate to forward Outlook events upon registrationJanuary 29, 2023
  • Why the condition is false for the same numbers (Power Automate)January 25, 2023
  • How to forward event invitation to other calendar (Power Automate)January 22, 2023
  • Run ‘For selected item’ flow from non-default environment (Power Automate)January 18, 2023
  • Hide button in SharePoint list after Power Automate flow startedJanuary 15, 2023

Power Automate blogs worth visiting

Damien Bird
Dennis (Expiscornovus)
Paul Murana

©2023 Let's POWER Automate | Theme by SuperbThemes