cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

I need to send e-mail alerts based on dates stored in Sharepoint lists

I am trying to send an email when a date on a sharepoint list is reached but I am struggling. Any help please? Complete beginner so take it easy, thanks.

 

image.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: I need to send e-mail alerts based on dates stored in Sharepoint lists

Hi DAGEM,

 

How is the Date column created in your list? I assume that it should be Date only.


Before using the formatDateTime function, you should know the date format in your list.


Please consider to use Compose action to get the format of the date column. You could create a simple flow likes below. In my case, it returns ‘yyyy-MM-dd’.

3.PNG

 

According to your scenario, create a flow to send an email when the date is equal to today.


I configure the Condition using the function: @equals(items('Apply_to_each')?['Date'], formatDateTime(utcnow(),'yyyy-MM-dd'))

4.PNG

 

Hope this could be a reference for you, please try it on your side and feel free post back if you need more help.

 

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
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

1 REPLY 1
Highlighted
Community Support
Community Support

Re: I need to send e-mail alerts based on dates stored in Sharepoint lists

Hi DAGEM,

 

How is the Date column created in your list? I assume that it should be Date only.


Before using the formatDateTime function, you should know the date format in your list.


Please consider to use Compose action to get the format of the date column. You could create a simple flow likes below. In my case, it returns ‘yyyy-MM-dd’.

3.PNG

 

According to your scenario, create a flow to send an email when the date is equal to today.


I configure the Condition using the function: @equals(items('Apply_to_each')?['Date'], formatDateTime(utcnow(),'yyyy-MM-dd'))

4.PNG

 

Hope this could be a reference for you, please try it on your side and feel free post back if you need more help.

 

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
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

Helpful resources

Announcements
Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

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

Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Top Solution Authors
Top Kudoed Authors
Users online (6,174)