cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kouliscon
Helper V
Helper V

Date recurrence formulas

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.

1 ACCEPTED SOLUTION

Accepted Solutions

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.

Best Regards,
Qi

View solution in original post

4 REPLIES 4
GarethPrisk
Resident Rockstar
Resident Rockstar

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

@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

GarethPrisk
Resident Rockstar
Resident Rockstar

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.

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.

Best Regards,
Qi

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,927)