When having two attachments, I get two e-mails

[Tobias_PCI]

Greetings everybody,

I'm in the middle of building a flow. Users are filling in a Form via Microsoft Forms, where they also can choose to upload one or more attachment. When uploading one attachment, I will get one e-mail, so everything works fine. When they upload two attachments, I get two emails with one attachment. I want to get one email with both attachments.

1. Here it gets the submitted form. It goes through a switch which is equal to a question in Forms

It looks if the chosen option from Forms is equal to the question in this switch.

If the chosen option is equal, then this switch is activated. Condition 2 looks is there is an attachment uploaded. If no, then an e-mail will be sended with the completed forms questions. 

Lets look to the "If yes" section:

.

The if yes section consist of the flow to extract the attachments and put it in the e-mail. What do I need to change to make this way more simplier and when there are more attachments, they get automatically uploaded in one e-mail. (with a for each loop for example) I did some research and saw some examples with SharePoint involved, but since the data is extracted from Microsoft Forms. I want to know what I do need to change tot achieve the goal.

Many thanks in advance. I'm gladly looking forward to a solution.

[v-bofeng-msft · Accepted solution]

Hi @Tobias_PCI ,

You are almost finishing this flow because you only need to add an array variable in your flow and move the “send an email” action outside the apply to each loop action. Please refer to below steps:

Before your “Condition 2” action, please create an “Initialize variable” action to store all the attachments in following steps:

Inside the apply to each action: you need to move the “send an email” action outside and add an “append to array variable” action instead:

As you can see, no need to change your “Get file content” action and inside the “Append to array variable” action, please write:

{

  "Name": ,                  //please select the name dynamic content generated by the Parse JSON action, don’t forget the ” , “ character in the end

  "ContentBytes":      // please select the File content dynamic content generated by the “Get file content” action

}

For the send an email action, please press the circled button in screenshot:

After this, your send an email action would be like this and you need to select the variable dynamic content for the attachment column and save the flow.

Now, your flow would be perfect no matter how many attachments your end users will upload, the flow will only send you one single email and all the attachments would be attached automatically.

Best Regards,

Bof

[Tobias_PCI]

Thank you very much for the simple explanation @v-bofeng-msft 

This was the correct solution!

[MMPowerAutomate]

The flow works for me, however I receive 1 e-mail with and 1 e-mail without the attachment. Any insights?