cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

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

Hi,

 

I'm using the reminder template below to send an email reminder when near to due date.ScreenHunter_21 Jun. 10 09.02.jpg

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

ScreenHunter_22 Jun. 10 09.05.jpg

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.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

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.

View solution in original post

13 REPLIES 13
Community Support
Community Support

Hi @doristok ,

 

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,

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

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

Summary.jpg

 

Flow 1.jpg

 

Flow 2.jpg

 

Flow 3.jpg

 

Flow 4.jpg

 

Flow 5-Scope to get items 1.jpg

 

Flow 5-Scope to get item 2.jpg

 

Flow 5-Scope to get items 3.jpg

 

Flow 5-Scope to get items 4.jpg

 

Flow 6.jpg

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

 

 

Hi @doristok ,

 

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,

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

Hi,

 

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

Hi @doristok ,

 

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,

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

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

 

ScreenHunter_21 Jun. 10 09.02.jpg

 

Hi @doristok ,

 

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

 

Best Regards,

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

Hi @doristok ,

 

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:

38.PNG

Please try again.

 

Best Regards,

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

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.

Hi @doristok ,

 

Have you tried to use my method?

 

Best Regards,

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

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.

Hi @doristok ,

 

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,

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

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.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (13,205)