Unanswered

Flow recurrence - Calculated time before end of month

(0) Share

Report

Posted on by Community Power Pla...

I am trying to a build a flow that sends an email one day before the end of the month and 7 days before the end of the month (calculating those days each month). I have no clue how to write the expression for that and recurrence trigger does not seem to provide me that optionr. Could someone help me write that expression or show me exactly how to set that up? Thank you so much.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

RezaDorrani 12,143 on at

Like (0)

Report

Re: Flow recurrence - Calculated time before end of month

@Anonymous

for the Recurrence trigger
go to settings and add the following as a trigger condition

@or(equals(formatDateTime( addDays(startOfMonth(addDays(startOfMonth(utcNow()),31)),-1),'MM-dd-yyyy'),formatDateTime( utcnow(),'MM-dd-yyyy')),equals(formatDateTime( addDays(startOfMonth(addDays(startOfMonth(utcNow()),31)),-8),'MM-dd-yyyy'),formatDateTime( utcnow(),'MM-dd-yyyy')))

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Flow recurrence - Calculated time before end of month

Thank you for your quick reply!

If i was running this on two separate flows (one for 7 days before and 1 a day before) are these the correct expressions? They each send a unique email.

1 day before
@if(formatDateTime( addDays(startOfMonth(addDays(startOfMonth(utcNow()),31)),-1),'MM-dd-yyyy'),formatDateTime( utcnow(),'MM-dd-yyyy'))

7 days before
@if(formatDateTime( addDays(startOfMonth(addDays(startOfMonth(utcNow()),31)),-8),'MM-dd-yyyy'),formatDateTime( utcnow(),'MM-dd-yyyy'))

I got this error when I tried to run them "Cannot read property 'properties' of undefined". And what is the best way to test these so I know they will run on specific dates? (Or do I have to wait until those days come around to see if it works?)

Was this reply helpful? Yes No