Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Sending Templated Emails Flow - Is there a better way?

I need to design a flow that will be used to send mass amounts of emails from 15 or so different templates. Each template may have a different attachment.


In the past I've been able to accomplish this on an individual level by putting all of the variable fields (such as name, personal message, email address, subject, etc...) into an excel table and having the flow build each email in an apply to each block. I've done this in excel because its what I learned to do, it works, and I can edit all the required fields in an excel file at once and send them out when I'm finishished.


So what I'm thinking for this flow to send emails from 15 different templates is that I'd have to get all the rows from an excel table, do 15 different filters, one for each template, and run each template through an apply to each block. There would of course be a field in the table that indicated what template to use.


The flow would look something like


manually trigger a flow

list rows present in a table

filter array (one for each template)

Apply to each (one for each template)

Send an email from a shared mailbox V2 inside each Apply to each



I'm not familiar with all of the tools microsoft has to offer so there may be something out there thats better and I dont know. The question is if there is a better or more efficient way to accomplish this? 

Community Support Team
Community Support Team

Re: Sending Templated Emails Flow - Is there a better way?

Hi @applegaming ,


Do you mean you have created 15 dirrerent flows to achieve your requirement?

If you don't want to manually trigger 15 different flow to send the email, you could create a flow with 15 branchs to send the email, and you only need trigger the flow for one time.



Best regards,



Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Level: Powered On

Re: Sending Templated Emails Flow - Is there a better way?

I planned to put them in the same flow so I would just have to trigger it once. I was asking about ideas that might involve other 365 applications / connectors to manage this process easier.

Helpful resources


Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.


Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.


Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Microsoft Learn

Learn how to build the business apps that you need.


Power Platform World Tour

Find out where you can attend!


Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Users Online
Currently online: 76 members 3,838 guests
Please welcome our newest community members: