web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate - Building Flows Flow recurrence - Calc...

Power Automate - Building Flows

Unanswered

Flow recurrence - Calculated time before end of month

(0) Share

Report

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.

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

RezaDorrani 12,141 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

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 659 Super User 2025 Season 2

#2

Tomac 386 Moderator

#3

chiaraalina 290

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans