cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Send a customized email when a new SharePoint list item is added

Dear Flow Users,

 

I am using the Flow Template called "Send a customized email when a new SharePoint list item is added". I would like to achieve the following

 

Objective : Create a Birthday SharePoint List and will send out emails listed on that SharePoint List.

 

Information : How do I ask SharePoint List to Validate todays date and send out the trigger to send the email?

 

When I send an EMail - i cannot send an HTML View Email or an attachment to it.

 

Look forward for your reply,

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Send a customized email when a new SharePoint list item is added

Hi @girijai,

 

Could you please share more information about Birthday SharePoint list?

I suppose that there is Date column in Birthday SharePoint list which is used to compare with today’s date.

Do you want to check the Date column of a new created item?

Or filter all items whose Date column meets the condition in Birthday SharePoint list?

  1. If you want to achieve the first one, you only need to add a Condition. If the condition is met, send an email to specific person. In Condition box, click “Edit in advance mode” and type the following formula:

@equals(formatDateTime(triggerBody()?['DateColumn'],'MM/dd'), formatDateTime(utcNow(), 'MM/dd'))2.jpg

 

       2.If you want to achieve the second, it is not necessary that use “When an item is created” as a trigger. We can use a recurrence trigger to instead of it.

Firstly, we need to get all items with “Get items” action and do some filter with “Filter array” action. In “Filter array”, configure From to Output of “Get Items” action and type the following formula in advance mode:

@equals(formatDateTime(item()?['DateColumn'],'MM/dd'), formatDateTime(utcNow(), 'MM/dd'))

Then we need to add “Apply to each” to output of “Filter array” action. In “Apply to each”, we add “Send an email” action.3..jpg

 

In order to send HTML View, we can add “Create HTML table” action before sending an email. Configure From property of “Create HTML table” action to an array. In body property of “Send an email”, we add output of “Create HTML table” action. Set Is HTML property of “Send an email” action to Yes.4.jpg

 

 

Besides, in order to add an attachment, we can configure Attachment Name and Attachment Content property as below:

 

5.jpg

 

Best regards,

Kris

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

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Send a customized email when a new SharePoint list item is added

Hi @girijai,

 

Could you please share more information about Birthday SharePoint list?

I suppose that there is Date column in Birthday SharePoint list which is used to compare with today’s date.

Do you want to check the Date column of a new created item?

Or filter all items whose Date column meets the condition in Birthday SharePoint list?

  1. If you want to achieve the first one, you only need to add a Condition. If the condition is met, send an email to specific person. In Condition box, click “Edit in advance mode” and type the following formula:

@equals(formatDateTime(triggerBody()?['DateColumn'],'MM/dd'), formatDateTime(utcNow(), 'MM/dd'))2.jpg

 

       2.If you want to achieve the second, it is not necessary that use “When an item is created” as a trigger. We can use a recurrence trigger to instead of it.

Firstly, we need to get all items with “Get items” action and do some filter with “Filter array” action. In “Filter array”, configure From to Output of “Get Items” action and type the following formula in advance mode:

@equals(formatDateTime(item()?['DateColumn'],'MM/dd'), formatDateTime(utcNow(), 'MM/dd'))

Then we need to add “Apply to each” to output of “Filter array” action. In “Apply to each”, we add “Send an email” action.3..jpg

 

In order to send HTML View, we can add “Create HTML table” action before sending an email. Configure From property of “Create HTML table” action to an array. In body property of “Send an email”, we add output of “Create HTML table” action. Set Is HTML property of “Send an email” action to Yes.4.jpg

 

 

Besides, in order to add an attachment, we can configure Attachment Name and Attachment Content property as below:

 

5.jpg

 

Best regards,

Kris

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

View solution in original post

Highlighted
Anonymous
Not applicable

Re: Send a customized email when a new SharePoint list item is added

Hi Kris @v-xida-msft

 

Many thanks for your support. Can you please specify your step in "Get Items" and "Filter Array" actions?

 

I cant select an array for the field From of "Filter array".

 

I used following for "Get Items"

Site Address: xxx.sharepoint.com/sites/hch/bday

List Name: "Geburtstage"

 

My SP list has two columns, 1. Mitarbeitende (Person) 2. Geburtstag (Date)

 

I look forward to hearing from you.

 

Thanks.

 

 

Helpful resources

Announcements
firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

Users online (11,921)