Answered

Email based on future date in sharepoint list

Like (0) Share

Report

Posted on 2 Dec 2022 02:30:42 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.

All responses (3)

Answers (1)

vandam2 on 11 Dec 2022 at 17:12:01

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)
vandam2 on 10 Dec 2022 at 00:18:08

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

v-liwei-msft on 02 Dec 2022 at 03:04:31

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