Send a reminder 14 days out from a due date

%3CLINGO-SUB%20id%3D%22lingo-sub-160285%22%20slang%3D%22en-US%22%3ESend%20a%20reminder%2014%20days%20out%20from%20a%20due%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-160285%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20create%20a%20flow%20that%20looks%20at%20a%20particular%20due%20date%20field%20in%20a%20sharepoint%20list%20and%20if%20the%20field%20is%2014%20days%20from%20today%2C%20sends%20a%20reminder%20email.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20can't%20get%20it%20to%20send%20a%20reminder%20for%20only%20the%20right%20entries%2C%20if%20I%20set%20the%20Condition%20to%26nbsp%3B%40greaterOrEquals(outputs('Compose')%2C%20items('Apply_to_each')%3F%5B'Abstracts_x0020_due'%5D)%3C%2FP%3E%0A%3CP%3EI%20get%20emails%20for%20every%20entry.%26nbsp%3B%20What%20I%20want%20is%20for%20it%20to%20look%20at%20the%20entry%20and%20if%20it%2014%20days%20from%20today%20it%20sends%20an%20email%20but%20then%20tomorrow%20it%20won't%20send%20it.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHow%20do%20I%20do%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-160285%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-162390%22%20slang%3D%22en-US%22%3ERe%3A%20Send%20a%20reminder%2014%20days%20out%20from%20a%20due%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-162390%22%20slang%3D%22en-US%22%3E%3CP%3Ehere%20is%20a%20hint%20on%20how%20to%20do%20this%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FBuilding-Flows%2FHow-to-get-last-two-weeks-of-data%2Ftd-p%2F16481%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FBuilding-Flows%2FHow-to-get-last-two-weeks-of-data%2Ftd-p%2F16481%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EThe%20most%20important%20part%20of%20that%20link%20is%20that%20your%20date%20can%20be%20transformed%20like%20this%3A%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E%22%40adddays(utcnow()%2C-14)%22%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EThe%20thing%20to%20remember%20when%20trying%20to%20search%20for%20answers%20is%20that%20queries%20are%20done%20using%20ODATA%20format%20now.%20Learning%20ODATA%20notation%20is%20something%20I%20am%20working%20on%20as%20I%20switch%20to%20O365%20and%20Flow.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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
Highlighted

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.