How can I set recurrence with the last day of month?

(2) Share

Report

Posted on by michael80321

I want to set a recurrence with the last day of month. Is it possible?

I know how to set the specific date in the following link

https://powerusers.microsoft.com/t5/General-Flow-Discussion/Is-there-a-way-to-get-a-monthly-reminder-in-Flow/td-p/14658

Thanks

Categories:

General topics

I have the same question (0)

All responses (9)

Answers (1)

Sort by

Verified answer

gamoraes 1,040 on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @michael80321.

Today we no have a simple way to do this, but i created a function that does,

The first print is my result and second is how i did. In my case just to explain i used a compose, but a the utcNow() function get the last day of current month

The function is the below:

"@adddays(concat(add(int(formatDateTime(utcNow(), 'yyyy')),if(equals(formatDateTime(utcNow(), 'MM'), '12'), 1, 0) ),'-',add(int(formatDateTime(utcNow(), 'MM')),if(equals(formatDateTime(utcNow(), 'MM'), '12'), -11, 1) ),'-01T00:00:00Z'),-1)"

I create a idea for do this more simple, please vote on it

I hope i have helped.

Best Regards,

Gustavo Moraes

Was this reply helpful? Yes No
michael80321 11 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Gustavo,

I try it, but nothings to display. Am I Doing it Wrong? Thanks a lot.

Was this reply helpful? Yes No
gamoraes 1,040 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi michael,

the second print don't show but you need put " after and before compose text, only this Microsoft Flow interpret as function. Copy all bold text than I post and put in your compose.

Best Regards,

Gustavo Moraes

Was this reply helpful? Yes No
michael80321 11 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you very much !!!
It works : )

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(6)

Report
Copy link

Link copied!
I took a slighly different approach.

At 2pm daily, my flow checks to see if today's date is less than tomorrows date. If it's not, then tomororw is the first day of a new month.

It specifically extracts the day of the month only.

Having said this, I haven't actually let it run past the end of a month yet... It should work but I havne't proven it yet

On the left of the condition is this:
convertFromUtc(utcNow(),'W. Australia Standard Time','dd')

On the right of the condition is this:
adddays(convertFromUtc(utcNow(),'W. Australia Standard Time'),1,'dd')

Was this reply helpful? Yes No
Nielf 306 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous ,

Did your flow run successfully when it ran past the end of April?

If it did - that's a very smart workaround - but it's really difficult to test 🙂

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Yes it did!

It is a bit tricky to test though... Apart from being very patient...

I'd kind of tested it by changing the 'Is Less Than' to 'Is Greater Than' and the flow still worked, but in the opposite direction.

Was this reply helpful? Yes No
Nielf 306 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous,

That's great.

I guess there are other ways to test it. However, you can't really be sure until you see it working with the specific logic.

I'm creating a flow right now based on your solution. Then I'll wait until June to see if it works

Thanks for your input.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@gamoraes Excellent, thank you for this. I needed it badly. Question, what if I just need yyy-mm-dd as ouput and discard the time zone stamp, what would be the adjustment to the formula. Thanks in advance.

Was this reply helpful? Yes No