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
Resident Rockstar
Resident Rockstar

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
Resident Rockstar
Resident Rockstar

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
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,723)