Unanswered

Power Automate Approval Timeouts based on Business Days

(1) Share

Report

Posted on by FocusRach

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:

Get Company Holiday Schedule (we have a SharePoint List).
Starting from the Approval Start Date, assess if that day is a Holiday or Weekend.
Once the start date is assessed, add 1 day to the start date, and assess the day after.
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.
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.
See variables and screenshots in the post below!

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

Categories:

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

I have the same question (0)

All responses (4)

Answers (0)

JW-02101845-0 Microsoft Employee on at

Like (1)

Report

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

Was this reply helpful? Yes No
FocusRach 63 on at

Like (0)

Report

@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!

Was this reply helpful? Yes No
TanyaMc 77 on at

Like (1)

Report

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/

Was this reply helpful? Yes No
FocusRach 63 on at

Like (1)

Report

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

Was this reply helpful? Yes No