Answered

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

(0) Share

Report

Posted on by girijai

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,

All responses (2)

Answers (1)

Community Power Pla... on at

Like (0)

Report

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.
Verified answer

v-xida-msft on at

Like (0)

Report
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?
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.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.

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.

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

Best regards,
Kris