Date recurrence formulas

(0) Share

Report

Posted on by kouliscon

247

hello all,

was wondering if i can have the following formulas: "Date of the Monday from the last week of each Month"

i would then run a recurrence every day and if the date of today is equal with the formula from the "Date of the Monday from the last week of each Month" then it will execute to do something.

let me know your thoughts pls.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

GarethPrisk 2,828 on at

Like (1)

Report
Copy link

Link copied!
When you say 'run a recurrence' - are you referring to a Flow on a schedule?

This is the Power Apps forum, but we can try to assist.

You could do a simple check, such a conditional branch with these two conditions:

dayOfMonth(addDays(utcNow(),7)) < dayOfMonth(utcNow())

This just gets the day of the month of the current day, and a week from today

If the value a week from today, is less than, the current day, then we know it'll the next month in a week

dayOfWeek(utcNow()) = 2

I think Monday's enumeration is 2, but you'll want to confirm

Either way, this would allow you to ALSO check if the current day was Monday

Was this reply helpful? Yes No
kouliscon 247 on at

Like (0)

Report
Copy link

Link copied!

@GarethPrisk thank you for your reply.

i was thinking that i need the formula at the canvas but now that i am thinking of it it might be better to have the formula at the flow... will move there.
thank you

Was this reply helpful? Yes No
GarethPrisk 2,828 on at

Like (0)

Report
Copy link

Link copied!

Right. The App could effectively work but there's no guarantee it's always going to be opened daily - or maybe there is. Don't know your exact scenario.

The Flow would be completely asynchronous and not rely on at least 1 user to open the app to execute.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @kouliscon,

I have seen that you have opened a new case here and it has been marked as an answer. I will mark here and close this case in Power Apps forum.

Thanks for your co-operation.

Was this reply helpful? Yes No