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:
Here is a picture of the error im getting
Here is a picture of the list I am getting the items from:
Any help would be greatly appreciated 🙂
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! 😅
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.
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
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.
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
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!
WarrenBelz
146,745
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional