Skip to main content

Notifications

GCC, GCCH, DoD - Federal App Makers (FAM)
Unanswered

Power Automate Approval Timeouts based on Business Days

Posted on by 63

Hi Federal Fam! 

I had a situation that required approvals to timeout based on business days (excluding weekends and company specific holidays). 

The approval connector does not allow for specification of day type (yet?), so I found a work around. 

 

Basic steps: 

  1. Get Company Holiday Schedule (we have a SharePoint List). 
  2. Starting from the Approval Start Date, assess if that day is a Holiday or Weekend. 
  3. Once the start date is assessed, add 1 day to the start date, and assess the day after. 
  4. For each day assessed, increase a variable count for vTotalDays that have passed and a separate variable count for all of the vBusinessDays that were identified. 
  5. Use the vTotalDays variable in a Switch case to have separate scenarios initiate depending on the number of total days that need to pass, to account for the number of business days desired.  This will allow you to create Approval Connectors that have different timeout durations set. 
  6. See variables and screenshots in the post below!


https://www.linkedin.com/posts/activity-7184966224441679872-wsSF?utm_source=share&utm_medium=member_desktop 

  • FocusRach Profile Picture
    FocusRach 63 on at
    Re: Power Automate Approval Timeouts based on Business Days

    This is a really well made article, @TanyaMc! It was easy to follow and well laid out. I appreciate you posting! 

  • TanyaMc Profile Picture
    TanyaMc 77 on at
    Re: Power Automate Approval Timeouts based on Business Days

    Thanks for sharing the links! I have a flow for assigning due dates to tasks that uses similar logic, since the due date is tied to number of working days after the request is received. It was 'fun' to build (not!). 

    I tried this method with do until but couldn't get it to work so I used a method that was less dynamic to meet the business case.

    https://www.penthara.com/how-to-dynamically-calculate-working-business-days-for-a-due-date-in-power-automate/

     

  • FocusRach Profile Picture
    FocusRach 63 on at
    Re: Power Automate Approval Timeouts based on Business Days

    @jwillisrose Thank you for sharing this in here as well! I'm running into an error with the Graph Mailbox Custom connector but I am going to spend more time with this to ensure I'm not missing any steps. This kit looks so promising, it's exciting! 

  • Re: Power Automate Approval Timeouts based on Business Days

    Thanks for sharing. I would also recommend checking out the Approvals Kit by Power CAT: Business approvals templates overview (preview) - Power Automate | Microsoft Learn

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

September 2024 Newsletter…

September 2024 Community Newsletter…

Community Update Sept 16…

Power Platform Community Update…

Tuesday Tip #2 Global Search…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 142,008

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,531

Leaderboard