Send an email reminder

[Turka89]

Hi Community,

I want to send an email reminder to the Task owner in a SharePoint Tasks list through a workflow. As follows:

1. Send an email reminder to task owner 1 day before due date

2. Send 2nd reminder to the task owner on the same target date 

3. Send an email every 3 day to task owner until the task is closed 

How do I achieve this

Thank you in advance

[v-litu-msft · Accepted solution]

Hi @Turka89,

If you want to send the first two reminder emails, you should create a Recurrence trigger runs every day.

Then create a condition to determine:

• The due date sub 1 days if equals to utcNow();
• Or target date if equals to utcNow();

If you want to send reminder Email every 3 days until the task is closed, you should create the other Recurrence trigger runs every day, then check the start day whether equals to today, if it is, start a Do until loop to send Email every three days until the task status is closed.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Turka89]

Hi @v-litu-msft 

Thank you so much for your inputs it worked 1st and 2nd reminder however, im facing issues with 3rd reminder. Emails still coming even though I have changed the task status to 'Completed'. Here is a screenshot

Thank you

[v-litu-msft]

Hi @Turka89,

What's the type of the Task status column?

If it is a choice column, you should use the dynamic content Task status value into the input of Do until action.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Turka89]

Hi @v-litu-msft 

Still getting emails. My scenario if Due date is less than Today date send emails every 3 days until task is completed.

Thank you

[v-litu-msft]

Hi @Turka89,

The Flow to send an email every 3 days to task owner until the task is closed should be:

1. Recurrence trigger runs every day;

2. Get items to filter items that Start date equals to today, formate date should be 'yyyy-MM-dd';

3. Then create a Do-until loop for these items to send reminder email every 3 days until status value equals to Completed.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Turka89 · Accepted solution]

Hi @v-litu-msft 

Your logic is correct, however, emails was still coming. I found this post which actually solved it for me.

https://powerusers.microsoft.com/t5/I-Found-A-Bug/Do-Until-question/m-p/54008#M920

Thank you so much for your time. Much appreciated!