excluding public holidays and weekends to send email

Like (0) Share

Report

Posted on 18 Jun 2024 06:03:46 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?

I have the same question (0)

All responses (3)

Answers (1)

aliska1bogati 16 on 20 Jun 2024 at 06:35:01

Like (0)

Report

Re: excluding public holidays and weekends to send email

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
Verified answer

v-yetonggu-msft on 18 Jun 2024 at 07:17:12

Like (2)

Report
Re: excluding public holidays and weekends to send email

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
Chriddle 8,141 Super User 2025 Season 2 on 18 Jun 2024 at 06:22:03

Like (0)

Report

Re: excluding public holidays and weekends to send email

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