cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
doristok
Level: Powered On

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
doristok
Level: Powered On

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

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 Team
Community Support Team

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

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.
doristok
Level: Powered On

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

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.

 

 

Community Support Team
Community Support Team

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

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.
doristok
Level: Powered On

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

Hi,

 

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

Community Support Team
Community Support Team

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

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.
doristok
Level: Powered On

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

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

 

Community Support Team
Community Support Team

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

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.
Highlighted
Community Support Team
Community Support Team

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

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.
doristok
Level: Powered On

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

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.

Community Support Team
Community Support Team

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

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.
doristok
Level: Powered On

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

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.
Community Support Team
Community Support Team

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

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.
doristok
Level: Powered On

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

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
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Users online (5,581)