Examples how I use Microsoft Power Automate with emails

For the past two years I have been using Microsoft Power Automate to automatically deliver standard emails both internally and externally. The reason I started working this way was because I wanted to speed up some admin type work that took a lot of time. This article looks at some of the advantages and disadvantages of using Power Automate as well as the structure of some example automatons.

Power Automate is an automation service that lets you create workflows not only between Microsoft apps (e.g. Outlook, Word, Excel, file storage) but also external apps or APIs. There is other automation / workflow software available but I use Power Automate since it is included in other licenses I already have. So there is no extra cost.

Advantages

The number one advantage I find with Power Automate is that it gives me full customization. This means I build solutions that match the way I work rather than the other way around.

The second advantage is that actions or steps can be automated based on logic and rules. In some flows I automatically create and tag documents based on the rules I’ve set up. If the answer to a question is this then do that. This enables me to work more efficiently since I can automatically filter my work.

The third advantage is it is possible to create a custom user interfaces in Powerapps which can be used for composing and sending emails (using templates) based on the information which has been stored. This is a little more advanced but is great since I can work remotely using my smart phone and cloud storage.

Disadvantages

A potential disadvantage I find is that Power Automate is focused on automation for individuals. However, with the use of a shared inbox and folders it is possible to create drag-and-drop functionality to save emails.

A second disadvantage is more about the need to be careful with email automation. This stuff is seriously powerful and needs to be handled with care. One day I accidentally triggered over 4,000 emails to be sent to three of my colleagues in the space of 5 minutes. It took a while before they started speaking to me again!

Example 1: incoming email

Work flow automation to save email attachments

In the scenario above I trigger a chain of actions when I move an email to a certain folder. The start of the flow involves manual input but the I save a lot of time by automatically filing the attachments. When I am in control of the subject line of emails or know of specific information in the email I trigger the actions based on extracting information in the subject line. I have used this structure in the past to automatically archive contracts.

Example 2: extracting text from email and sending new email

Below is another example. When an email arrives I convert the HTML in the email body to text so I can use functions similar to regular expressions to extract the data I am interested in.

Steps to extract text from an email
Finding specific text in an email using “indexof” and “substring” functions

A potential use of this is creating automatic sales emails. Once I receive a notification email (e.g. someone responded to an online form) I send an automated email with dynamic content. An email that triggers and email.

The interface used to create a template email with dynamic fields

Example 3: sending notification at the end of a process

The third example when I use Power Automate with emails is at the end of processes. In this example I have a process running and once it is completed either myself or other people are notified automatically. This saves time again since people don’t need to go searching for information about whether a process is finished.

Sending emails at the end of an automated process

Using these techniques I send 100s of emails automatically each week. It is a great time saver and can easily be set up by anybody.

Lawyer and Citizen Developer. Founder of LegalBot.io. Passionate for digitalising and automating legal work. Co-founder of Corporate Legal IT Forum.

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Top 5 Routine Habits of Highly Successful People

The Art of Finishing

The art of procrastination …

Tomorrow is a mysterious country, where 99% of the motivation and tasks are.

A How-to Guide for a More Productive Home Office

Working with ADHD

Why I Am Using “Notion” To Manage My Personal Life, Studies, and Career

Why You Should Create a Second Brain

How To Resume FSc Preparation After Eid?

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Henrik Hjertstedt

Henrik Hjertstedt

Lawyer and Citizen Developer. Founder of LegalBot.io. Passionate for digitalising and automating legal work. Co-founder of Corporate Legal IT Forum.

More from Medium

Power Automate as a Low-Code Tool for Augmenting Daily Processes

Create a Custom Connector for Consumption Logic Apps using the Azure Portal

Git Aliases — My Daily Git Commands

https://unsplash.com/photos/cOkpTiJMGzA?utm_source=unsplash&utm_medium=referral&utm_content=creditShareLink

Date table using Power Query