Multiple Attchments in one email flow

[emckinney81]

Flow community

I am trying to send two attachments that are stored in onedrive for business in a single flow. 

Here is the setup:

1. One excel spreadsheet that has the contact list for the emails to send to in onedrive for business. 

2. Two pdf files in onedrive for business

Currently i have the flow working if it sends one file out. I just do a get content on one of the aforementioned filed then put that in the attachment content field in the office 365 send email connector.  I also fill out the body and the to with various information. The trouble i am having is how to send two attachments in the send email connector. I did a second get content on the other file, but the "dividers" i tried to tell flow to send it as two seperate attachments didnt work. I tried a colon, semi-colon and a comma to seperate the file name and the content. Neither worked or it sent the flow and concatenated the pdf and file name. Which of coursed caused an error when trying to open the file in the email. 

Looking to see if multiple attachments is supported in the Outlook 365 Send Email connector, if so how do you tell the connector to make it two attachments? 

[v-xida-msft]

Hi @emckinney81,

Could you please share a screenshot of your flow’s configuration?

Sending multiple attachments within one “Send an email” action of Outlook is not supported in Microsoft Flow currently, if you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

You could consider send two attachments within two separated emails, please take a try with the following workaround:

The flow works successfully as below:

Best regards,

Kris

[emckinney81]

Thank you for the reply. I was able to do it with the help of a friend on the product team. Long story short I had to initialize a variable with the type array. Then append to the variable with the content I got from the onedrive. Then put the variable in the attachment field. 

I can screen/document this if the community would like to see. It works great and was very helpful. 

Eric

[Anonymous]

A screen dump would be pretty rad! 

[JonL · Accepted solution]

This blog shows you how as well!

https://preview.flow.microsoft.com/en-us/blog/multiple-attachments-single-email/

[Anonymous]

Hi,

I'm struggling to get this to work, maybe I'm missing something?

I followed the Flow of the Week blog instructions and I'm getting errors on the Outlook O365 Send Email action.

I have managed to send 2 text files but other text files throw an error on sending email and png and json files error constantly.

So as an example:

This works in the Attachments field:

[
  {
    "Name": "test - Copy.txt",
    "ContentBytes": "test"
  },
  {
    "Name": "test.txt",
    "ContentBytes": "test"
  }
]  

But this doesn't:

[
  {
    "Name": "NewTextDocument.txt",
    "ContentBytes": "tttttt"
  },
  {
    "Name": "pa.txt",
    "ContentBytes": "pa test"
  },
  {
    "Name": "test - Copy.txt",
    "ContentBytes": "test"
  },
  {
    "Name": "test.txt",
    "ContentBytes": "test"
  }
]

The error is:

Thanks

Jan

[emckinney81]

Do you have the steps to Get File Content for the additional two files? 

[Anonymous]

Hi,

Yes it's just looping round the list item attachments in an Apply to Each.

It works fine with 2 particular text files but other files throw this error. Screenshot from run history below.

[Sru]

hi all,

 i am getting below error when trying to send mulitple attachments from list item in email.Userd Array to store the file name and content. If i send one file each time it works but when i  use the array in send email it throws below exception.

have anyone faced this issue? i tried to remove the action and added but no luck

{
  "status": 400,
  "message": "No input parameters provided. Please provide required input parameters 'To', 'Subject' and 'Body'.\r\nclientRequestId: 9190770f-4790-4779-9e17-ee0a37d61b6c",
  "source": "office365-ncus.azconn-ncus.p.azurewebsites.net"
}

Thanks,

Sru

[Anonymous]

I used the directions provided in this blog upto the point that it gets to "Send An Email" I want to be able to use "Send An Email With Options"., however when it goes through the FLOW the actions stops with the following error: 

The request failed. Response content: '{"status":400,"message":"Required property is missing.\r\nclientRequestId: 6b863281-a94c-41a6-8af0-afd88fe32e71\r\nserviceRequestId: a0b51b59-332f-413e-974b-8c2550d12331","source":"office365-ncus.azconn-ncus.p.azurewebsites.net"}'.

Any suggestions on what I'm missing?

[Sru]

Hi @Anonymous,

i followed the articles shared in earlier post. We need to use below expression for the ContentBytes parameter instead of the dynamic variable which comes up.It worked and able to send files as attachments in one mail.

body('Get_attachment_content').$content

Thanks,

Sru

[Anonymous]

Hello @Sru,

Thanks for the reply, I dont understand how you are getting the "body('Get_attachment_content').$content" when I select attachement content it only provides the attachment content.

 

[Sru]

hi @Anonymous,

use expression option and copy paste the expression as is "body('Get_attachment_content').$content".

i am using Get attachment content action before appending the array variable.attached screen print for the same

[Anonymous]

@Sru

I tried the expression and it successfully completes the acction of "Append to array variable", but it's not completing the send email with options when selecting the variable "Attachment"

 

[Anonymous]

Hi @Sru,

Thanks for your help! I think I got what went wrong. I noticed in your screen shot that the expression was different than what was typed. I went back and corrected it and used body('Get_attachment_content')['$content'] and this worked. I am now able to send an email with options and multiple attachments! 

[PhilipCaldwell]

I have been able to create an attachment array and have it email the approver the attachments.  However, where I run in to an issue is when the attachment file is a text ( .txt ) file.  When that happens, it does not build the attachment array and stops the flow with an error:

[Anonymous]

Philip, I just came across this myself. The get file attachment $content seems to work with every file I've tried, except txt files. So, for this, I figured a way to do the text files differently, and that action is just configured to run with the existing append to array variable action fails, using the 'configure run after' options, set it to run after a fail of the previous action.

The second append action uses the formula 
base64(body('Get_attachment_content')), and this works for text files in my testing. 

and that works for the text files. Good luck!

[Mario_SLB]

base64(body('Get_attachment_content')) worked for me! I was having issues with a .zip file.

Thanks!