cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
girijai
Level: Power Up

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
Community Support Team
Community Support Team

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
Community Support Team
Community Support Team

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

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
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,006)