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.
Solved! Go to Solution.
@ramanjjilunaidu can you try below approach?
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.
@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...
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.
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.