Last day of the month

(0) Share

Report

Posted on by alhilo

Hi Everyone

I have a flow that send an email one time on each month. " Please see the below link"

https://ibb.co/xJXyTK2

I need this flow to work in the last day of each month. So, my question is if I insert the start time 2020-10-31T06:00:00.000Z

in which day in the below months the flow will work

November/2020

December/2020

January/2021

February/2020

Thank you so much

Categories:

General topics

All responses (5)

Answers (0)

Sort by

Brad_Groux 4,556 on at

Like
a
(2)

Report
Copy link

Link copied!
You have a few different ways to determine the last day of the month.

Determine if today is the last day of the month, such as when you schedule a flow to run daily:

If(Month(Today()) = Month(Today()+1), "Not Last Day Of Month", "Last Day Of Month")

Subtract from first day of the month, to get the last day of the month, for when you want to run flow on a schedule:

subtractFromTime(startOfMonth(addToTime(utcNow(),1,'month')),1,'day')

The Time intelligence functions (DAX) has loads of ways to determine the time/day, including ENDOFMONTH, and ENDOFQUARTER.

If you could provide an expanded screenshot of your Flow and steps, your Flow run history, and of any detailed error messages you're receiving we could likely better assist you. Also, for the best results, you may want to review How to write a good forum post.

If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION ☑️. If you find this reply helpful, please consider giving it a LIKE.
alhilo 93 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your reply

could you please advise where I should write the below equation

subtractFromTime(startOfMonth(addToTime(utcNow(),1,'month')),1,'day')
Brad_Groux 4,556 on at

Like
a
(1)

Report
Copy link

Link copied!
You have a few options, including in an expression in a condition, a variable, or via a function.

Understand data operations - Power Automate | Microsoft Docs

Use expressions with conditions. - Power Automate | Microsoft Docs

Add a condition to a flow - Power Automate | Microsoft Docs

If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION ☑️. If you find this reply helpful, please consider giving it a LIKE.
Ankeshk690 2 on at

Like
a
(0)

Report
Copy link

Link copied!

How can I delete the files before 1 month (depending on the total days of the month ) and schedule the automated workflow for the last day of the month?
MichChrdk 38 on at

Like
a
(0)

Report
Copy link

Link copied!

here is what i did.
I made a recurrence trigger, once a month on the 29th (due to february and not taking leap year into account i realise). Then a compose action with the above expression, then a condition "utcnow = compose" ? no? Delay action 1 day. No action in "yes". Havent tested it yet, but hopefully it should continue loop delaying from the 29th till the 30/31st and then run.