Multiple emails from flow designed to send new list item details via email

[bwright]

Hi everyone,

I am very new to flow creation.  I have built a flow to send an email when a new item is entered into a list.  The body of the email contains the data entered in the new list item.  Attachments from the new list item are also sent as an attachment in the email.  At this point, the email output contains everything that it should.  The issue is that flow is sending the email 4 times.

I am sure this is due to the "apply to each" portion of the flow.  I have tried to move the send email part outside of the "apply to each" portion, but it does not work.

The first "for each" control was created to get the new list item attachment content.

The 2nd-4th "for each" controls were created automatically by Flow when I added the respective field from the list item to the output email body.  Each of the fields allow for more than one selection when creating the item.  These fields are "Category", "Items", and "Who needs to be involved?"

How do I correct this flow so that output email stays the same, but send sonly once?

[ccc333ab · Accepted solution]

Yes, the 4 emails are due to the loops. You will want to send the email outside these loops, but to get your "multiple" attachments and "multiple" values from your list, you'll need to build up some "containers" to hold them in and attach them once into the email. 

Of note, you won't be able to send multiple attachments in the "Send Email Notification (v3)" action. I would recommend using the Outlook function Send an email (v2). I'll show you below one way to do all this: 

For attachments:

1. Initialize a variable of type Array
2. Loop through all attachments, and add it into the array variable. 
3. In the Send an Email (v2), switch to use input array, and include your dynamic content from your array variable. 

(Hit the yellow highlighted button to use input array)

For Multiple values

1. Initialize a string variable for all of your 3 fields that are of multiple values (category,  items, etc.)
2. Loop through each one and append to your string variables
3. Use this variable in your email 

(See this post: https://powerusers.microsoft.com/t5/General-Power-Automate/New-to-Power-Automate-Copying-items-from-...). 

This appends a comma after each loop, so you may want to put in logic to remove the last one if you want, or don't add it on the first loop, while adding the comma at the beginning of all other loops. 

[bwright]

Thanks so much for your reply!  This is working great for the multiple values issue, however I am unable to get the attachment to send with the email...attachment structure is setup per your advice using Send an Email v2.

Any thoughts on the attachment missing?

[ccc333ab]

Are you able to grab a screen shot of: 

• Your append to array variable action
• Your Send an Email v2 action

[bwright]

I figured it out...I typed "Content" in the array variable action instead of "contentbytes"

Thanks for your help with this!

[HarshavardhanG]

Hi @bwright , 

Can you please post the steps post suggestions by ccc333ab ?

The screenshots of your final flow will help users (like me) who visit this thread in the future.

[bwright]

Hi @HarshavardhanG,

Absolutely.  Below is the finished flow.