cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Receiving multiple emails

Hi all I am trying to create a action tracker that can send emails when an action in a list is due. The issue I am having is that I am receiving multiple emails when I only want to receive one. For example in my list lets say I have 3 due items I will receive 3 duplicate emails.

I tried removing the "apply to each 2 loop" but I end up getting an error. Does anyone how to solve this issue?

Here is a picture of my complete flow:
Due Date tracker 2 flow 1.png

Due Date tracker 2 flow 2.png

Here is a picture of the error im getting

Loop error.png

Here is a picture of the list I am getting the items from:

List.png

Any help would be greatly appreciated 🙂

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User II
Super User II

Re: Receiving multiple emails

So the reason the loop gets created is because an array of items is returned, therefore it would send a individual email about each item.

 

to get around this you would need to retrieve each unique user into an array and then query the array of returned items against that list, and then process as reqired.

View solution in original post

6 REPLIES 6
Highlighted
Dual Super User III
Dual Super User III

Re: Receiving multiple emails

Hi @Anonymous 

 

As you have the send email action in the apply to each loop, that definitely is one reason that you are getting multiple emails. Can you move it out and then as you already are appending the details to a string variable, directly pass this to the email action outside the loop and see if you continue to face the same issues? 

 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Highlighted
Super User II
Super User II

Re: Receiving multiple emails

Please check out the built in flow template, it is for this use case, it sends 1 email of all items at a specific interval try it out. You can launch the template from the SharePoint List -> Flow -> Remind Me -> Pick Date Column

Highlighted
Anonymous
Not applicable

Re: Receiving multiple emails

Hi Gristy, yes I did use the in built flow template.  If you recall you were the one who recommended me to use the template in one of my previous posts and you recommended me to tweak it to my liking. However the "tweak" I am trying to achieve is that I want to send the email/ email notification to the action owner as shown in the sharepoint list instead of myself .  And when I do this the flow automatically inputs an apply to each loop which sends me multiple emails, attempting to remove it will give me the error as shown in the post.

I hope this gives you more information on the difficulties I am facing.

Highlighted
Anonymous
Not applicable

Re: Receiving multiple emails

Hi Yashag, yes I have tried that but I still get the same issue of the Apply to each loop automatically appearing and sending me multiple emails. If I attempt to remove it I will get the same error. I hope this provides more info into the difficulties I am facing. I am not sure how to progress from here

Highlighted
Super User II
Super User II

Re: Receiving multiple emails

So the reason the loop gets created is because an array of items is returned, therefore it would send a individual email about each item.

 

to get around this you would need to retrieve each unique user into an array and then query the array of returned items against that list, and then process as reqired.

View solution in original post

Highlighted
Anonymous
Not applicable

Re: Receiving multiple emails

I see, thanks for that! But would it be possible for you to demonstrate how to this for me?  Desperate to get this to work! 😅 

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

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!

Top Solution Authors
Users online (7,398)