Reminder Emails N-2, N-1 and on Nth day using Flow designer where is "N" is last working date field

[Harsha M V]

Hi All,

I need to build a flow designer where we need to send reminder emails N-2 days, N-1 day and on Nth day, where N is last working date field in a RITM. This has to ignore the weekends and holidays while sending reminder emails.

I am stuck on how to get the dates of N-2, N-1 and use it in flow so that flow will wait till that date to send reminder emails.

Please help me with the logic and scripting to build the flow.

[Vishal Jaswal]

Hello @Harsha M V 

I would encourage you to try of your own and if it is not working or you encountered some errors then share those details like share your complete flow and share those actions which aren’t working for you.

[Ankur Bawiskar]

@Harsha M V 

you can use flow variable and use Set Flow Variable logic and use inline script.

refer this link on how to subtract and get days using schedule

you want to subtract the dates using schedule

check this link

Calculate Date By Adding or Subtracting Time With A Schedule 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[SanjivMeher]

I think you can build 3 separate flow for this to address each scenario.

The Flow can be a Scheduled Flow, which will run every day to query all the RITMs has the N-2 days. And then send the email using events or notifications.

Similarly add another flow to run everyday to query RITMs has tbe N-1 day and repeat the same.

One more for Nth Day, all RITM which has a last working day of today and send notifications for each.

You can then figure out how to exclude holidays or weekends