Solved

Exclude weekends and public holidays and send notification

2 years ago
12 July 2021
13 replies
232 views

ramanjjilunaidu
43 replies

Hi Team,

I want to send alerts to manager every day for three days after submitting a new item in list. But here i have a requirement that i have to exclude weekends(Friday & Saturday) and public holidays some i have given below.

New Year's Day Fri, 1 Jan 2021
Eid al-Fitr Eve 2 May 2021
Commemoration Day 30 Nov 2021
National Day Thur, 2 Dec 2021 (here i have exclude thursday, friday & Saturday), if reminder date is falling on 2nd Dec, email should trigger on 5th Dec.)

Any suggestions would be highly appreciated.

Regards,

icon

Best answer by kunalpatel 15 July 2021, 19:01

View original

13 replies

+12

kunalpatel
Novice
648 replies
2 years ago
13 July 2021

@ramanjjilunaidu can you try below approach?

Create a list for Holidays, you will have to keep this updated

Query the list and filter date column of the list with your date and store it in collection

Using collection operations, get the count of that collection

Using Format Date function, get the day of the your date
1. Add Run If and condition will be day in #1 is not Fri or day in #1 is not Sat or num_HolidayCollecCount = 0
  1. Send email alert to your manager

Dear Kunal,
Thanks for your solution, since i am a newbie, second point is not clear for me, i would request you to explain in brief please....................

My Holiday list is as follows.

And my filter is as follows and i don't know whether i have to take start date or end date column in filtering. LMFReminder is a calculated column(Created+1) in main list(not holidays list)

thanks in advance.

+12

kunalpatel
Novice
648 replies
2 years ago
13 July 2021

@ramanjjilunaidu in your holiday list why you have start and end date? If holiday is on a certain day then all you need is the date when that holiday falls.

Create 2 columns i.e. Date of Holiday - Date Type and Holiday as SLT

e.g. 12/24/2021 - Christmas Eve

12/25/2021 - Christmas

12/31/2021 - New Year Eve

01/01/2022 - New Year

Now when querying holiday list get ID collection and apply filter Alert_Date = Date of Holiday? If that is not same then collection will be empty.

Now for 2nd part i.e. for weekends...

Create a SLT variable i.e. slt_Alert_Day

Using build string action use below formula and store it in above variable
formatDate(Alert_Date, ddd) - this formula will give the day of Alert_Date in 3 letters, you can use dddd to get the full spelling

Add Run If action and configure by adding below 3 filter conditions using OR operations
1. slt_Alert_Day not equal Fri
2. slt_Alert Day not equal Sat
3. num_Holiday_Count = 0

Inside this run if action add your email notification

@kunalpatel ,

1. I am getting Holiday Count(num_Holiday_Count) blank as below.

List query is as follows

2. Even though my holiday on 15 July 2021 and alert date is 15 July 2021, email getting generated.

i have a holiday on 15 which is falling on thursady still email is triggering

My Run If condition is as follows.

Regards,

Dear All,

No one is there to help me out, can anyone guide me please..........

Regards,

@cassymfreeman can you please help me as i am getting date collection blank and query list is as above.

Thanks in advance.

+12

kunalpatel
Novice
648 replies
2 years ago
15 July 2021

@ramanjjilunaidu after using Query List, did you use the Collection Operations to count the collections and store it in the number variable?

@kunalpatel

Dear Kunal, i would request if you can create NWF(i hope it won't take more than 10 mns) and provide me the solution(attach it here). Appreciate if you can do this please........................................................

Thanks in advance.

Regards,