Power Platform Community Forum Thread Details

Hi,

I want to send remainder email to respective users based on the due date.

I need to calculate approaching due date for 2 weeks before from current date

1 week from current date and a day before the due date .

I have the 8 columns (Requirement date, design due date, solution due date, test plan date, test exit date likewise) in dataverse. all the 8 columns has the different due date but sometimes possible to get the same due date.

I need to filter the columns based on the due date which is approaching 2 weeks , 1 week and a day before to send the remainder email.

Note:(If the date falls on weekend like sat or sunday the email should go only weekdays not weekends)

How to create the schedule flow for these scenario? Kindly help me to achieve it.

Thanks.

Categories:

General topics

1) you would create a recurrence flow to run daily, except for Saturday and Sunday

2) You don't have one due date, you have 8, so you'll have to filter each of them separately. Since Dates include both date and Time normally use a filter array for each of the 8 dates to filter based on the each date being between two dates. You can calculate the two dates using the AddDays() function and UtcNow(). For example for the two weeks out calculate AddDays(utcNow(), 14) and AddDays(utcNow(),13). if the date is greater than the first and less than the second its 14 days out. On Mondya you would adjust the calcuation to check for things 14, 15, and 16 days out by adjusting the AddDays formulas.

3) After you have the filtered array for each category and each due date you can use apply to each loops to send the emails.