6
I have a sharepoint column named due date, and I have to trigger 3 mails before the due date in the order: 1st-(due date-10 working days), 2nd- (due date-7 working days), 3rd- (due date-5 working days). Weekend have to be excluded from the 10, 7, 5 days subtracting only working days from due date.
How we can achieve this please let me know.
Hi @ShivaniR25
Based on your description, I have made a simple test for your reference.
Here is the flow:
Share
Report
All responses (
Answers (
dayOfWeek(utcNow())@or(equals(formatDateTime(item()?['DueDate'], 'yyyy-MM-dd'), addDays(utcNow(), 12, 'yyyy-MM-dd')),equals(formatDateTime(item()?['DueDate'], 'yyyy-MM-dd'), addDays(utcNow(), 9, 'yyyy-MM-dd')),equals(formatDateTime(item()?['DueDate'], 'yyyy-MM-dd'), addDays(utcNow(), 5, 'yyyy-MM-dd')))@or(equals(formatDateTime(item()?['DueDate'], 'yyyy-MM-dd'), addDays(utcNow(), 14, 'yyyy-MM-dd')),equals(formatDateTime(item()?['DueDate'], 'yyyy-MM-dd'), addDays(utcNow(), 9, 'yyyy-MM-dd')),equals(formatDateTime(item()?['DueDate'], 'yyyy-MM-dd'), addDays(utcNow(), 7, 'yyyy-MM-dd')))@or(equals(formatDateTime(item()?['DueDate'], 'yyyy-MM-dd'), addDays(utcNow(), 14, 'yyyy-MM-dd')),equals(formatDateTime(item()?['DueDate'], 'yyyy-MM-dd'), addDays(utcNow(), 11, 'yyyy-MM-dd')),equals(formatDateTime(item()?['DueDate'], 'yyyy-MM-dd'), addDays(utcNow(), 7, 'yyyy-MM-dd')))
Hope it helps.
Best regards,
Sylvia
