To use Flow to send 1 reminder email but it sent more than 1

[Anonymous]

Hi,

I'm using the reminder template below to send an email reminder when near to due date.

Print Screen below is the recurrence and days to remind the recipients.

I would like the Flow to send only 1 reminder email 2 days before the due date. But, this Flow is sending email reminder 2 days before the due date on daily basis even after the due date.

How to fix this problem to send only 1 reminder email and stop further reminder after this.

[v-bacao-msft]

Hi @Anonymous ,

Could you share details of the templates you use? Link or detailed screenshots to help us do more analysis.

I speculate that the filtering conditions configured in Scope led to this situation.

Please provide more details and we would provide proper workaround for you.

Best Regards,

[Anonymous]

Hi,

Thanks for your swift reply.

1st print screen below is the overview and follow with the  expanded on each trigger/actions. Below with my inputs and the rest I follow the data in the template.

1. Recurrence

2. Days to remind me in

3. The emails in the Scope to get items due in 1 day

The due date is of the file to be updated is on 4th June. But auto reminders were sent after the due date.

[v-bacao-msft]

Hi @Anonymous ,

Could you please provide a link to this template or a related article?

I am afraid that although you have provided a very detailed screenshot, I still have some confusion, so I can't reproduce a similar issue.

Best Regards,

[Anonymous]

Hi,

Could you teach me how I can provide the link to this template?

[v-bacao-msft]

Hi @Anonymous ,

I noticed that the advanced mode is still in use in the Condition. This feature has been removed so I guess you are using the Flow configured with the previous Flow template.

If you are indeed using a template, you could tell me its name so that I can search for it.

I am sorry that it seems a bit difficult for me to rebuild this Flow according to your description. I don't know details of Expressions and Get list name by HTTP request actions you use.

Best Regards,

[Anonymous]

I get the standard template by go to the sub-folder, then click on Flow>Set reminder>Due Date per print screen below.

[v-bacao-msft]

Hi @Anonymous ,

Thank you for your tips, I will do further testing.

Best Regards,

[v-bacao-msft]

Hi @Anonymous ,

I tested it on my side according to your prompts. Maybe the logic of this Flow template makes you confused.

The intent of this Flow is to filter the items whose Due Date is equal to the current date plus x days.

If such items exist, send a reminder email.

You could check if the Body of the email reminder received every day is the same.

Check if Title is the same, if it is not the same, the Flow has been executed as expected, and the reminder email is not sent repeatedly.

In addition, if Due Date field does not include time, you could change Filter Query by referring to the following configuration:

Please try again.

Best Regards,

[Anonymous]

Hi,

Thanks for checking.

Unfortunately, the Body of the email reminder received every day is the same. Thus, I need to turn off the Flow to stop sending the reminder.

[v-bacao-msft]

Hi @Anonymous ,

Have you tried to use my method?

Best Regards,

[Anonymous]

I didn’t try on the time as the due date is sufficient.

You mentioned a reminder should send. So, this Flow suppose to send 1 email reminder right? Do you able to find out why it happened to send more than 1 reminder and on daily basis.

[v-bacao-msft]

Hi @Anonymous ,

It seems to be affected by configuration in Filter Query.

The judgment contains time, and the time zone set in the trigger may not be the same as the time zone set in SharePoint.

You could use the method I provided to verify the problem. If my method is work, it seems that the problem is that the configuration of Filter Query cause different results.

Best Regards,

[Anonymous · Accepted solution]

Hi,

I'm trying your method. I will need to wait for few days to check is the reminder send on daily basis and after due date.

Thanks.