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.
Solved! Go to Solution.
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.
This is my list:
Here is the Flow:
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.
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.
This is my list:
Here is the Flow:
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!! 🙂
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!
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!!
User | Count |
---|---|
102 | |
37 | |
31 | |
24 | |
16 |
User | Count |
---|---|
132 | |
53 | |
53 | |
37 | |
26 |