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.

Categories:

Using flows

I have the same question (0)

All responses (7)

Answers (1)

Haritha222 14 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
esfeir4 13 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Haritha222 113 on at

Like (0)

Report
Copy link

Link copied!

Hi,

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

Regards
Haritha

Was this reply helpful? Yes No
Verified answer

v-dezhili-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
esfeir4 13 on at

Like (0)

Report
Copy link

Link copied!

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 ?

Was this reply helpful? Yes No
esfeir4 13 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-dezhili-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No