cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
girijai
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
v-xida-msft
Community Support
Community Support

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
v-xida-msft
Community Support
Community Support

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

Anonymous
Not applicable

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
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (72,907)