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.

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-liwei-msft on at

Like (0)

Report

Re: Email based on future date in sharepoint list

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

Was this reply helpful? Yes No
vandam2 on at

Like (0)

Report

Re: Email based on future date in sharepoint list

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.'.

Was this reply helpful? Yes No
vandam2 on at

Like (0)

Report

Re: Email based on future date in sharepoint list

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

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

Was this reply helpful? Yes No