How to create a flow that runs always in the middle and at the end of month, like on the 15, and at the end, 30 or 31 depends on the month

(0) Share

Report

Posted on by esfeir4

Hello everyone,

I have a flow that I need to trigger it twice a month, in the middle and at the end.

The problem is that if I set the recurrence to 15 days, it runs every 15 days, which does not work in my case, like this month is february it ends on 28, 15 days from Feb 15 takes me to March instead of the end of February.

Is there a way to tell automate to run on the 15th and the end of every month? Whether it's 28,30 or 31 ?

Thanks.

All responses (7)

Answers (1)

v-dezhili-msft Microsoft Employee on at

Like (0)

Report

Re: How to create a flow that runs always in the middle and at the end of month, like on the 15, and at the end, 30 or 31 depends on the month

Hi @esfeir4 ,

It runs on the 15th of every month and the last day of every month.
You can also set the time at which the flow will start running.

Best Regards,
Dezhi
esfeir4 13 on at

Like (0)

Report

Re: How to create a flow that runs always in the middle and at the end of month, like on the 15, and at the end, 30 or 31 depends on the month

Also, do I keep the interval 1 day as shown in your screenshot ? the additional function we added overrides it ?
esfeir4 13 on at

Like (0)

Report

Re: How to create a flow that runs always in the middle and at the end of month, like on the 15, and at the end, 30 or 31 depends on the month

Hello! Thank you for this, just wanted to ask, any idea at what time this starts ? or at midnight once it's the 15th or the end of the month ?
Verified answer

v-dezhili-msft Microsoft Employee on at

Like (0)

Report
Re: How to create a flow that runs always in the middle and at the end of month, like on the 15, and at the end, 30 or 31 depends on the month

Hi @esfeir4 ,
You can get the first day of the next month and subtract one day to get the last day of the month.
Then set the condition in the trigger condition, if today is the 15th or today is the last day of the month, run the flow.
Please try:

@or(equals(forMatDateTime(utcNow(),'dd'),'15'),equals(formatDateTime(addDays(startOfMonth(addToTime(utcNow(),1,'Month')),-1),'dd'),forMatDateTime(utcNow(),'dd')))

If you want to test the flow manually you need to replace the '15' in the formula with your current date, otherwise the flow will not run.

Best Regards,
Dezhi
Haritha222 113 on at

Like (0)

Report

Re: How to create a flow that runs always in the middle and at the end of month, like on the 15, and at the end, 30 or 31 depends on the month

Hi,

https://nebulaaitsolutions.com/how-to-set-scheduled-flow-to-run-on-specific-dates-of-a-month/
Please check above link.

Regards
Haritha
esfeir4 13 on at

Like (0)

Report

Re: How to create a flow that runs always in the middle and at the end of month, like on the 15, and at the end, 30 or 31 depends on the month

The problem is that if I set the recurrence to 15 days, it runs every 15 days, which does not work in my case, like this month is february it ends on 28, 15 days from Feb 15 takes me to March instead of the end of February.
Haritha222 14 on at

Like (0)

Report

Re: How to create a flow that runs always in the middle and at the end of month, like on the 15, and at the end, 30 or 31 depends on the month

Hi,

Step 1: go to scheduled cloud flow..
Step 2:
Step 3: select repeat every 15 days run a flow.

Please try this.

Regards
Haritha