Answered

Email based on future date in sharepoint list

(0) Share

Report

Posted on by vandam2

Hello everyone, i a new to powerautomate, i have an event list with a future event date, i would like to send email alert on the morning of the date of the event

not sure how i could do this, or if there is a template i could use.

thank you in advance for any help you can provide.

Categories:

General topics

All responses (3)

Answers (1)

Sort by

Verified answer

v-liwei-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @vandam2

You can create a flow that starts every morning at a fixed time.
Create a condition to determine whether the date column is equal to today's date and send a reminder email if it exists.

Best Regards,

Levi
vandam2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Levi, if my date is 'Start Date' column, what should i use for the formula,

formatDateTime(items('Apply_to_each')?['Start Date'], 'yyyy-MM-dd')

i tried this but get error

i get this error when i run the test
InvalidTemplate. Unable to process template language expressions for action 'Condition_2' at line '0' and column '0': 'The template language function 'formatDateTime' expects its first parameter to be of type string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#formatdatetime for usage details.'.
vandam2 on at

Like
a
(0)

Report
Copy link

Link copied!

Couldn't get the the formatdatetime to work but the substring did work

substring(item()?['StartDate'],0,10)