Sending a beautifully formatted email from Microsoft Flow

I recently shared a winning use case for Office 365. Within this use case, I am using Flow to send beautifully formatted emails to our users. Something like:

formatted email from microsoft flow

Okay, maybe it’s not that beautiful, but it is colorful, has an image, and pops in comparison to black and white text only emails.

Microsoft Flow sends formatted emails with ease.

The Send Email action has a property under advanced options to enable HTML emails, which allows for formatting:

microsoft flow send email html.png

As long as you know HTML, you can send beautiful emails. DONE!

What if I don’t know HTML?

I know HTML but I didn’t want to write the HTML for this email. Call me lazy, or too busy, or just intuitive :D. Instead, here’s what I did, and what I suggest to you.

Create a new email in Outlook.

Style the email: add colors, content placeholders, images, tables, etc. For content placeholders, put something obvious like %%FULLNAME%%, %%LINK TO SOMETHING%%, %%MESSAGE%%, etc. Whatever data you expect the Flow to load for you. Something to make the text pop out to your eyes later on.

Email yourself the email.

Open the email you just sent to yourself in Outlook. Open it in a new window, not in the preview pane in your Inbox. Go to Message tab, then More Move Actions > Other Actions > View Source. It’s kind of hidden:

view source of email.png

Don’t be scared! If you don’t know HTML, the resulting action of clicking above might have your eyes hurting. That’s OK!

You should see something like this:html source of email.png

Look for your content placeholders, I see mine, %%FULL NAME%%, right about halfway down. What’s all that other stuff on the page? HTML! Don’t worry about it. Copy all of this content and paste it into your Flow Send an Email action.

Now replace your content placeholders with dynamic values from Flow!

microsoft flow send email action with html.png

That’s it! Just make sure Is HTML is set to yes.

Images are tricky

A quick note on images. Outlook takes the image you included in your email and converts it to a string, to plain text. I found copy/pasting this didn’t work in Flow. I think the text ends up being too long in this action and it breaks.

Instead, what you should do is upload the image to the cloud. I used our marketing system Pardot, but you could upload it to a Google Drive, OneDrive for Business, a blog site, anywhere. Get the anonymous visitor URL to the image itself, and swap that out for the image.

Look for <image src=”ab2md3m… in the HTML and change the value of the src property to the URL of the image.

That’s it!

I hope this little trick works for you. Alternatively, you could find a WYSIWYG editor somewhere and format your email and then copy/paste that HTML as well. I find, that since the email was made in Outlook, it’s source is very Outlook friendly.

14 thoughts on “Sending a beautifully formatted email from Microsoft Flow

Add yours

  1. This was amazing and beautiful. How do I clean up the brackets from the form field?

    RESPONSE DATE: 11/26/2018 8:34:14 AM
    CONTACTED BY: Justin Jones
    MARKETING SOURCE: [“Sidewalk sign”]
    PREVIOUS CONTACT HISTORY: Nope, this is our first encounter.


  2. This worked great for me…I can see a beautiful logo in my flow generate email, however, others only see the alt text and box with a red x. I cannot find anything online to help me figure out why I can see it, but others cannot. Also how do I find the anonymous visitors URL?


    1. Where is the logo image stored? If it’s in SP, then the user would have to authenticate against SharePoint and then they can see it. Email client, like Outlook, won’t prompt for authentication.


  3. This is great!
    I used to make a better looking table in the email sent from flow.
    However, I have a problem that my auto-signature (which normally is in a table with no borders) also gets the style of the table, which I do not want.
    How can I end the style of the content that comes from flow, so my autosignature keeps its original style?

    Liked by 1 person

  4. This is a great tip. Previously I was creating Word templates, populating them, converting them to PDFs and then sending them via e-mail. This cuts out all those steps. Thanks so much!!!


    1. Yes! You can’t. ;)

      Emails cant use an authenticated source for images. Maybe if you did an anonymous link to OneDrive, that may work. I find I have to put the images into a public location like my blog or git. Sorry I wish there was a better story.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create a free website or blog at

Up ↑

%d bloggers like this: