flow to send an email 1 day prior the Date column

(0) Share

Report

Posted on by kouliscon

247

hello,

I need some assistance since I cannot make this reminder to work.

I have a SharePoint list with a date column called "Assignment Due Date"

I then created the below flow:

Reminder1DayPrior pic2.png

I am trying to test the flow so I set the recurrence to run every 5minutes but it doesn't seem to work as I don't receive any email

i also noticed that when i test at the GET ITEMS at the OUTPUT i get empty without data

Reminder1DayPrior pic3.png

thank you

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Pstork1 69,599 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

The problem is that the assignmentduedate column contains both a date and Time even if you set it for Date Only. Date Only will be recorded as that date with the time component set to midnight. So checking for the date to be equal to some UTCNow will never realistically happen. You need to test the date for greater than yesterday and less than tomorrow.

Was this reply helpful? Yes No
kouliscon 247 on at

Like
a
(0)

Report
Copy link

Link copied!

thank you @Pstork1 for the detailed info, how do I do that:
- greater than yesterday
- less than tomorrow?

thanks

Was this reply helpful? Yes No
Verified answer

Pstork1 69,599 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!
try this

AssignmentDueDate gt 'formatDateTime(addDays(utcNow(),-2),'yyyy-MM-dd')' and AssignmentDueDate gt 'formatDateTime(utcNow(),'yyyy-MM-dd')'

Make sure to include the single quotes and enter the formatDateTime() functions using the expression bar.

Was this reply helpful? Yes No
kouliscon 247 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @Pstork1 that worked like a charm.

for me to understand, what you gave me is basically required because I test it with 5 minutes interval.
if I would leave it as I intent to the recurrence to happen every 1 day I can leave the initial expression?

thank you

Was this reply helpful? Yes No
Pstork1 69,599 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

The formula I gave you checks to see whether the assignment date is later than yesterday and earlier than tomorrow. So if you change the recurrence to daily the formula should still work.

Was this reply helpful? Yes No
kouliscon 247 on at

Like
a
(0)

Report
Copy link

Link copied!

thank you @Pstork1

Was this reply helpful? Yes No
kouliscon 247 on at

Like
a
(0)

Report
Copy link

Link copied!

@Pstork1 can you assist? I have another post for an email to send out if the status is in "in progress" after two days.

so is similar with 1 day prior but I would like to happen 2 days after.

the post can be found here: https://powerusers.microsoft.com/t5/Building-Flows/Flow-to-send-an-email-2-days-past-due-date/m-p/625269#M82992

Was this reply helpful? Yes No