web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Count skip weekends/ho...
Power Automate
Unanswered

Count skip weekends/holidays

(0) ShareShare
ReportReport
Posted on by 33

I have set up an flow to send out a approval request when there is a new document submitted in the selected folder and this approval process will be closed in 72hrs.

The system will send out a reminder mail to inform assignees, if they don't sign the request in 36hrs.

There is a problem I faced, I don't know how to let system don't count the weekends/holidays.

Could anyone can give me any advises?

I really appreciate 😃

 

Janice_Lee_0-1640833016742.png

 

Categories:
I have the same question (0)
  • vikulkar Profile Picture
    on at
    Re: Count skip weekends/holidays

    Hi @Janice_Lee ,

     

    Since the delay is not always 36 hours, you will have to have an additional logic to add the additional delay.

    Here are some date and time functions that you can utilize to identify which day it is and then add 36 hours / 36+ hours to the delay action conditionally depending on the current time.

    Date and Time Functions Description
    addDays Add some days to a timestamp.
    addHours Add some hours to a timestamp.
    addMinutes Add some minutes to a timestamp.
    addSeconds Add some seconds to a timestamp.
    addToTime Add a number of time units to a timestamp.
    convertFromUtc Convert a timestamp from Universal Time Coordinated (UTC) to the current time zone.
    convertTimeZone Convert a timestamp from the source time zone to the current time zone.
    convertToUtc Convert a timestamp from the source time zone to Universal Time Coordinated (UTC).
    dayOfMonth Returns the day of the month part from a time.
    dayOfWeek Returns the day of the week part from a time.
    dayOfYear Returns the day of the year part from a time.
    formatDateTime Returns the date from a timestamp.
    getFutureTime Returns the current timestamp in addition with the specified time units.
    getPastTime Returns the current time minus the specified time units.
    ticks Returns the property value for a specified time.
    utcNow Returns the current time as a string.

     

    Also there should be another condition to check if there are any holidays in-between as well which can be done by maintaining the holiday dates in a SP list.

    The flow logic might seem a little complex but this is one way to approach the problem.

     

    Thanks and Regards,

    Vikas K

     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 532 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 461 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 256

Last 30 days Overall leaderboard