Unanswered

excluding public holidays and weekends to send email

(0) Share

Report

Posted on by aliska1bogati

Hi All,

Can someone please help me with the idea that I have created a flow which send email once a month excluding weekends but i need help how can I exclude Public Holiday?

Categories:

General topics

I have the same question (1)

All responses (3)

Answers (1)

Chriddle 8,434 Super User 2025 Season 2 on at

Like (0)

Report

Here I perform an “OffDayCheck” which determines whether the dates are on a weekend or in a “holidays” list.

This might give you some inspiration.

Was this reply helpful? Yes No
Verified answer

v-yetonggu-msft on at

Like (2)

Report
Hi @aliska1bogati ,

You might consider creating an Excel Table for weekdays。

Like this:

Flow Configuration:

First, use the Filter array to determine whether today is a working day, if today is a working day, then send an email, if not, we put the difference between all the workdates in the excel table and today's date into an array, and then we filter out the records less than 0 in the Date array, and then delay the minimum difference in days, and the day when the email is sent is the next working day.

utcNow('yyyy-MM-dd')

length(body('Filter_array')) div(sub(ticks(items('Apply_to_each')?['workday']),ticks(utcNow('yyyy-MM-dd'))),864000000000) item()?['Date'] First(sort(body('Filter_array_2'),'Date'))['Date']

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
aliska1bogati 16 on at

Like (0)

Report

Hi Sunshine,
Thank you for this guide.
Could you please help me how can I exclude Friday, Saturday and Sunday, at the moment I am using delay for Saturday and Sunday with the expression how can I run the flow?

Was this reply helpful? Yes No