cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MikeRooker
Helper V
Helper V

May one fo you experts please point me towards where I can learn how to use "email templates" to be placed in "Send Email" in Power Automate?

I tried to follow this YouTube "Microsoft Flow Tutorial: How to Send a Custom Email with Microsoft Flow", which may be a little dated from Dec 19, 2018, but some of the steps seem unclear to me and a deviates in usage for me since my recipients are to be retrieved from a person/group column and not a list.

The email template list looks very useful.


Here's a sample of the list above.

email template.PNG

 
Thanks in advance for any help.
 
 
 
1 ACCEPTED SOLUTION

Accepted Solutions
DeepakS
Super User
Super User

Hi @MikeRooker 

 

Here is an example flow that read the email template and send email.

Email Template SP list: i have similar list as you have for email template. Please note the email template column type is multi line text with following properties.

emailcolumn.png

 

This is my list:emaillist.png

Here is the Flow:

Email.png

 

I have also uploaded flow at if you want to download

https://github.com/DeepakS22/DPowerAutomate/blob/master/SendEmailfromTemplateList_20200317043002.zip

 

 

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

 

 

View solution in original post

4 REPLIES 4
DeepakS
Super User
Super User

Hi @MikeRooker 

 

Here is an example flow that read the email template and send email.

Email Template SP list: i have similar list as you have for email template. Please note the email template column type is multi line text with following properties.

emailcolumn.png

 

This is my list:emaillist.png

Here is the Flow:

Email.png

 

I have also uploaded flow at if you want to download

https://github.com/DeepakS22/DPowerAutomate/blob/master/SendEmailfromTemplateList_20200317043002.zip

 

 

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

 

 

That look amazing and thank you.
DeepakS may I ask, would I be able to replace the "To" in the email calling with the usernames from a person list column?

 

Thank you!! 🙂

@MikeRooker 

Sure you can! LEt's assume the Person column name is 'myPersonColumn'

IS your person column configured as single value or multivalue?

 

If single value and:

-data extracted from the trigger: triggerBody()?['myPersonColumn']?['Email']

-data extracted inside an array to each that iterates all through the items from a SP list: item()?['myPersonColumn']?['Email']

-data extracted from a 'Get item': body('Get_item')?['myPersonColumn']?['Email']

 

IN each of these three examples you can also select the output from dynamic content menu, specially useful when column name has special characters (and please note space is special character also)

 

IF not single value, please let us know

Thanx!

 

 



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



DeepakS, I have to thank you for going the extra step and including a zip file to follow through. I am so grateful!

Props and shout out to efialttes for follow up.
I tell you, you folks , we are so blessed to have you! Thank you so much!!

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

AI Builder AMA June 7th carousel (up on May 25th, take down June 8th) (1).png

'Ask Microsoft Anything' about AI Builder!

The AI Builder team invite you to ask questions and provide helpful answers at our next AMA.

Users online (1,474)