Power Platform Community Forum Thread Details

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 😃

Categories:

Building flows

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