Send a reminder 14 days out from a due date

Copper Contributor

I am trying to create a flow that looks at a particular due date field in a sharepoint list and if the field is 14 days from today, sends a reminder email.

 

I can't get it to send a reminder for only the right entries, if I set the Condition to @greaterOrEquals(outputs('Compose'), items('Apply_to_each')?['Abstracts_x0020_due'])

I get emails for every entry.  What I want is for it to look at the entry and if it 14 days from today it sends an email but then tomorrow it won't send it.  

 

How do I do this?

1 Reply

here is a hint on how to do this https://powerusers.microsoft.com/t5/Building-Flows/How-to-get-last-two-weeks-of-data/td-p/16481

 

The most important part of that link is that your date can be transformed like this: "@adddays(utcnow(),-14)"

 

The thing to remember when trying to search for answers is that queries are done using ODATA format now. Learning ODATA notation is something I am working on as I switch to O365 and Flow.