cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
emckinney81
Level: Powered On

Multiple Attchments in one email flow

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? 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Administrator
Administrator

Re: Multiple Attchments in one email flow

16 REPLIES 16
Community Support Team
Community Support Team

Re: Multiple Attchments in one email flow

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:13.JPG

The flow works successfully as below:14.JPG

 

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
emckinney81
Level: Powered On

Re: Multiple Attchments in one email flow

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

nsettnes
Level: Powered On

Re: Multiple Attchments in one email flow

A screen dump would be pretty rad! 

Highlighted
Administrator
Administrator

Re: Multiple Attchments in one email flow

Jan
Level: Powered On

Re: Multiple Attchments in one email flow

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:

 

sendemailerror.PNG

Thanks

 

Jan

emckinney81
Level: Powered On

Re: Multiple Attchments in one email flow

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

Jan
Level: Powered On

Re: Multiple Attchments in one email flow

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.

 

applytoeach.PNG

Sru
Level 8

Re: Multiple Attchments in one email flow

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
Not applicable

Re: Multiple Attchments in one email flow

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?

 

2018_08_22_16_00_08_Edit_your_flow_Microsoft_Flow_and_9_more_pages_Microsoft_Edge.png

Sru
Level 8

Re: Multiple Attchments in one email flow

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

 

a1.PNGa2.PNG

 

Thanks,

Sru

 

Anonymous
Not applicable

Re: Multiple Attchments in one email flow

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.

 

2018-08-23 08_34_39-.png 

Sru
Level 8

Re: Multiple Attchments in one email flow

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

a3.PNG

 

 

Anonymous
Not applicable

Re: Multiple Attchments in one email flow

@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"

 

2018-08-23 09_04_19-Edit your flow _ Microsoft Flow.png2018-08-23 09_03_12-Run History _ Microsoft Flow.png 

Anonymous
Not applicable

Re: Multiple Attchments in one email flow

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! 

 

options email with multiple attachments..png

 

 

PhilipCaldwell
Level: Powered On

Re: Multiple Attchments in one email flow

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:

 

build_attachment_array_textfile_error.PNG

levijohnson
Level: Powered On

Re: Multiple Attchments in one email flow

pic.pngPhilip, 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!

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Users Online
Currently online: 399 members 3,076 guests
Please welcome our newest community members: