cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Gristy
Resident Rockstar
Resident Rockstar

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

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!

Gristy
Resident Rockstar
Resident Rockstar

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

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.

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

Gristy
Resident Rockstar
Resident Rockstar

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

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
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (4,096)