last day of next month

Like (0) Share

Report

Posted on 7 Nov 2024 11:16:51 by Andy83

Hi All

I have a flow which runs on the last day of each month. At the moment I have to go into the flow on the first of each month and set it again for the last day.

Each time the flow executes I want to store the last day of the month for next month within a variable and use the variable to trigger the flow.

I'm thinking get the start of the month add two months and subtract a day.

I've got the start of the month fine its just the adding two months and subtracting a day I can't get working.

Any help much appreciated.

Thanks

Categories:

Business Process Flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

David_MA 12,264 Super User 2025 Season 2 on 07 Nov 2024 at 13:37:52

Like (1)

Report

last day of next month

If you start the schedule of the flow on a month that has 31 days, and set the interval to 1 month, the flow will run on the last day regardless of the number of days in the month.

I have been testing this method for several months now and it seems to work. I cannot find this documented anywhere, but Run flows on a schedule in Power Automate - Power Automate | Microsoft Learn does note: If you run a flow on the month frequency, the flow runs on the same date each month.

Was this reply helpful? Yes No
Chriddle 8,141 Super User 2025 Season 2 on 07 Nov 2024 at 13:28:04

Like (0)

Report
last day of next month

Not very elegant, but I can't come up with something beter:

- Schedule the flow to run once a day

- Check if utcNow('yyyy-MM-dd') equals the following expression (last day of the current month):

addDays( startOfMonth( addDays( startOfMonth(utcNow()), 32 ) ), -1, 'yyyy-MM-dd' )

- If not, terminate the flow

Note that your local date must match the UTC date at the time your flow runs.
Otherwise, things get more complicated.

Was this reply helpful? Yes No