How to stop duplicate emails being sent for every due date notification?

(0) Share

Report

Posted on by Bexibobs

Hello,

Hoping someone can help.

I have a sharepoint list with policy titles, the owner of each policy (email format), and the due date for renewal.

I have created a flow that sends a reminder email each month to the relevant policy holder to notify them which of their policies are due within the next 60 days.

I have created a table to list all due policies in one email and this worked. However, for every policy due, it is sending a duplicate email to the policy owner (so when 5 polices are due, 5 emails are being sent). How do I stop the flow from repeating the "send email" action for every policy due? I feel that it may be due to the "apply to all" within the emails, but surely I need this for the dynamic content I have placed in the "To" box (Owners emails)?

Screenshots:

Flow 1.JPG

Flow 2_LI.jpg

Flow 3.JPG

Thank you,

Rebecca

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

eric-cheng 5,171 on at

Like (0)

Report

Hi @Bexibobs ,

Currently your flow will loop through all returned items in your list and send an email for each item.

To do what you want, you will need to perform some sort of grouping via loops. Please have a look at this blog to do this.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No
Bexibobs 11 on at

Like (0)

Report

Hi @eric-cheng ,

Thank your for sharing this, I have spent some time following the process on this blog. However, the process seems to miss out what should be placed in the "log UniqueNames" which looks like it may be a "Compose" data operation. Any idea what I should place in this step?

Was this reply helpful? Yes No
RezaDorrani 12,143 on at

Like (0)

Report

Hi @Bexibobs ,

Check out this video https://youtu.be/tp0jLnmKcEs

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

Was this reply helpful? Yes No
Verified answer

Bexibobs 11 on at

Like (0)

Report

Just to update anyone reading this - I managed to resolve this issue by using this link:
https://tomriha.com/send-one-email-per-user-with-multiple-sharepoint-items-in-power-automate/

Was this reply helpful? Yes No