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

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

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

Re: Receiving multiple emails

Hi @RyanTan 

 

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!

Super User
Super User

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

RyanTan
Level: Powered On

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.

RyanTan
Level: Powered On

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

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

RyanTan
Level: Powered On

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

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

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

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,163)