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

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
Dual Super User III
Dual Super User III

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

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

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

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

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

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (11,579)