Send an email 3 days before a date in SharePoint

(0) Share

Report

Posted on by cardinalnight

212

I have a date ReturnDate which is a date column in SP.

I need a flow to send an email 3 days before this date.

I've tried:

Send Email 3 days before due date - Power Platform Community (microsoft.com)

ReturnDate eq '@{formatDateTime(addDays(utcNow(),7),'yyyy-MM-dd')}'

This doesn't work as it says syntax is incorrect.

and this:

ReturnDate eq addDays(utcNow(), 3)

this doesn't work as it says syntax is incorrect also.

Help please!?

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Sort by

BCBuizer 22,833 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @cardinalnight ,

From a syntax perspective this looks fine, so can you please share the error details you receive?

I did notice the name of your column is different from what you posted, so can you try:

ReturnDate eq '@{formatDateTime(addDays(utcNow(),7),'yyyy-MM-dd')}'

Was this reply helpful? Yes No
Riku 37 on at

Like
a
(0)

Report
Copy link

Link copied!

Are you trying to create a trigger based on a date in SP? Could you just run your automation daily to check if today is -3 days from the due date?

You could build a condition that says something like:

Where Outputs represents today in the correct format and the latter suggests due date -3 days to give the condition a true value: @{formatDateTime(addDays(variables('DueDate'),-3),'yyyy-MM-dd')}

Was this reply helpful? Yes No
cardinalnight 212 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi - this is the error for the first formula:
and I get the same error for the second:
ReturnDate eq formatDateTime(addDays(utcNow(),3),'yyyy-MM-dd')

Was this reply helpful? Yes No
cardinalnight 212 on at

Like
a
(0)

Report
Copy link

Link copied!

And I get an error for this one as well:

Was this reply helpful? Yes No
Riku 37 on at

Like
a
(0)

Report
Copy link

Link copied!

Paste this (or whatever you have) directly into the Inputs field of Compose and NOT the Expression.
@{formatDateTime(addDays(variables('DueDate'),-3),'yyyy-MM-dd')}

Was this reply helpful? Yes No
Riku 37 on at

Like
a
(0)

Report
Copy link

Link copied!

So I would suggest Composing the date you need (Due date -3 days) and then using this. Would it work then? 🙂

Was this reply helpful? Yes No
cardinalnight 212 on at

Like
a
(0)

Report
Copy link

Link copied!

It seems to be accepting this formula now - I've changed the formula, within the get items action to:
ReturnDate eq 'formatDateTime(addDays(utcNow(),3),'yyyy-MM-dd')'
but it's not sending an email. Is the addDays correct with the 3 in there? Should it be -3?

Was this reply helpful? Yes No
Verified answer

Riku 37 on at

Like
a
(0)

Report
Copy link

Link copied!

Assume that due date is today (2024-05-23)
addDays -3 results in: 2024-05-20
addDays 3 results in: 2024-05-26

Btw, If I helped you, click like and accept it as a solution :). Let me know if you need more help.

Was this reply helpful? Yes No