Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Date recurrence formulas

(0) ShareShare
ReportReport
Posted on by 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.

  • Verified answer
    Re: Date recurrence formulas

    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.

  • GarethPrisk Profile Picture
    GarethPrisk 2,826 on at
    Re: Date recurrence formulas

    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.

  • kouliscon Profile Picture
    kouliscon 247 on at
    Re: Date recurrence formulas

    @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 Profile Picture
    GarethPrisk 2,826 on at
    Re: Date recurrence formulas

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,434

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard