Delay Three Days then Send Email

(0) Share

Report

Posted on by Phineas

5,323 Super User 2025 Season 2

I have a flow that reads the 'Test_Date' (DateTime column) of an SP List, and if three days have passed the flow sends out an email.

Below is the 'Test_Date' column content from the SP List - In this example 6/2/2023 should initiate the email.

Below are the flow components. The run did not generate an email. What am I missing? Do I need a compose to re-format the date?

I have the same question (0)

All responses (1)

Answers (0)

David_MA 12,908 Super User 2025 Season 2 on at

Like (0)

Report
Re: Delay Three Days then Send Email

In my experience, date filters always take into account the time even if you have your field set to use the date only. If I wanted to get items created three days ago (June 2), I would use this filter query:

The first expression used is:

addDays(startOfDay(utcNow()),-3)

and the second expression is:

addDays(startOfDay(utcNow()),-2)

See if that works for you. In a run I tested this, it returned the following. The top compose is the date difference between the Created and utcNow. The bottom compose is the value of the Created date.

So if you use equals (eq), it never returns anything.

Was this reply helpful? Yes No