Flow sends duplicated emails - Send an email from a shared mailbox V2

[Bartek97]

Hi,

I built a flow that is sending automatic email when status of the Item in the Sharepoint List is changed to "Ticket to be sent".

There's a condition that is checking the status value and then another condition checking if the item has attachments.

If there are attachments flow sends an email and then after 3 minutes another one which is slightly modified. If there are not attachments flow is sending emails without the files. 

Everything works perfectly, apart the fact that flow is sending duplicated emails: it sends almost immediately the same 2 emails and after that it sends 2 duplicated emails. So to sum up, it should be sending 2 emails but it's sanding 4.

I'd appreciate any help with getting rid of duplicated emails. It only started a few days ago, I didn't change anything in the flow and suddenly it started sending double emails. I also checked with users and they're not changing the status more than 1 time.

This is how the flow looks like:

Closer look:

Closer look to part with email with attachment:

[creativeopinion]

@Bartek97 The reason why duplicate emails are being sent is because of where the Send an Email action is in your flow. 

It's nested INSIDE an Apply to Each action. This means if your item has more than one attachment—it will send an email for each attachment (as it's looping through each attachment using the Apply to Each action)

I have a couple of tutorials that will help you out with your issue:

• 3 Mistakes YOU 🫵 are Making with the Apply to Each Action in your Microsoft Power Automate Flow
• How to Send SharePoint List Attachments 📎 via Email with Power Automate

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

[Bartek97]

hi @creativeopinion,

thank you for providing the links, it's very helpful.

I modified the flow as below and got rid off Send email action in Apply to each. However, it still send duplicated email even when there's only one attachment.

Additionally I can't convert dynamic column from sharepoint to String. Previously I was using this expression 

string(items('For_each')?['DYNAMIC_x0020_COLUMN']) and now I tried 

string('DYNAMIC_x0020_COLUMN') but it's not working.

Best regards,

[Bartek97]

Hi,

Issue with content coming from calculated columns is solved.

However, flow still sends double emails no matter how many attachments there are: 0,1,2, or 6, it always send the same email twice.

Best regards,

[creativeopinion]

@Bartek97 The reason you are getting two emails is because you have two Send an Email actions in each branch of your condition action.

[Bartek97]

• @creativeopinion This how this flow should work. What I meant is that each of those emails is sent twice.

So instead 2 emails I get 4

[creativeopinion · Accepted solution]

@Bartek97 I don't see how you would be getting duplicate emails then as your email actions aren't inside an Apply to Each loop.

Could you check your Message settings in Outlook? If you have Group into conversations selected, it can look as though two emails are sent.

However this isn't the case, the top item (with the chevron (arrow)—is the group) as you can see there is only one email. 

If you change the Message settings to Show each message separately it will display each message separately.

Note how the email below doesn't have a chevron (arrow to the left).

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok