cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

flow to send an email 1 day prior the Date column

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

 

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Dual Super User II
Dual Super User II

Re: flow to send an email 1 day prior the Date column

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. 



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

7 REPLIES 7
Highlighted
Dual Super User II
Dual Super User II

Re: flow to send an email 1 day prior the Date column

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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Highlighted
Helper II
Helper II

Re: flow to send an email 1 day prior the Date column

thank you @Pstork1 for the detailed info, how do I do that:

- greater than yesterday

- less than tomorrow?

 

thanks

Highlighted
Dual Super User II
Dual Super User II

Re: flow to send an email 1 day prior the Date column

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. 



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

Highlighted
Helper II
Helper II

Re: flow to send an email 1 day prior the Date column

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

Highlighted
Dual Super User II
Dual Super User II

Re: flow to send an email 1 day prior the Date column

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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Highlighted
Helper II
Helper II

Re: flow to send an email 1 day prior the Date column

thank you @Pstork1 

Highlighted
Helper II
Helper II

Re: flow to send an email 1 day prior the Date column

@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/62... 

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (9,326)