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

Email Attachments in Flow

I am making a workflow for a SharePoint list. I want to send an email notification when a new item is created. However, I am not able to include attachments from the list to the email. 

 

Below is my flow:

Beginning of My Flow.PNG

 

 

My question is, how do I add the array to the "attachments" section of the email?

 

End of My Flow.PNG

 

I would greatly appreciate an answer from Flow experts! 

 

*Note: I did try using the "Compose" action instead of the "Initialize variable" action, but the emails coming from the Flow do NOT allow me to open documents. With the "Compose" action, I was able to create a variable and include that "Output" in the Attachments Content section of the email... However, that did not function properly (as noted, I was not able to open documents).

2 ACCEPTED SOLUTIONS

Accepted Solutions
Community Support Team
Community Support Team

Re: Email Attachments in Flow

Hi @nd13,

 

The error message told that you haven't enter information for To, Subject and Body of the email in the Send an email action.

 

Please make sure to add value to the To, Subject and Body of the email in the Send an email action, make sure to save the flow, and then run the flow to see if the issue still exists.

 

Please let me know if your problem could be solved.

 

 

Best regards,

Alice

View solution in original post

nd13
Level: Powered On

Re: Email Attachments in Flow

Yes! The issue has been  resolved. The error was in the "Append to array variable" step. Here is what worked: 

Capture.PNG

 

 

Here is the full flow: 
Full Flow.PNG

View solution in original post

28 REPLIES 28
rookie
Level: Power Up

Re: Email Attachments in Flow

Hi,

 

Now that you have stored the file name and contents of the attachment in a variable, you can configure the variable directly in the Attachments field.

51.PNG52.PNG

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

Community Support Team
Community Support Team

Re: Email Attachments in Flow

Hi @nd13,

 

Have your problem been solved?

 

As @rookie said, please switch to input entire array for the attachments by click the icon below:

Capture.PNG 

 

 

Please let me know if your problem could be solved.

 

Best regards,

Alice

nd13
Level: Powered On

Re: Email Attachments in Flow

I attached the Attachment Array as you showed:

 

AttachmentArray.PNG

 

However, my problem isn't resolved. Despite attaching the array, I get errors for the Flow. 

Flow Error.PNG

 

Am I skipping a step or missing something?

 

Community Support Team
Community Support Team

Re: Email Attachments in Flow

Hi @nd13,

 

I have made a test on my side and don't have the issue that you mentioned.

 

Could you please share more details about the error message in the "Send an email" action when the flow run failed?

Please share the full error message with me so we would try to provide a proper workaround for you.

Capture.PNG

 

 

Best regards,

Alice

nd13
Level: Powered On

Re: Email Attachments in Flow

Here is the full error message: 

 

 {
"status": 400,
"message": "No input parameters provided. Please provide required input parameters 'To', 'Subject' and 'Body'.\r\nclientRequestId: 2d6934f6-5b0f-42de-bb0e-367cdc0545fd",
"source": "office365-ncus.azconn-ncus.p.azurewebsites.net"
}
 
 
This is odd, because I have included content in the "To", "Subject", and "Body" sections. 
Community Support Team
Community Support Team

Re: Email Attachments in Flow

Hi @nd13,

 

The error message told that you haven't enter information for To, Subject and Body of the email in the Send an email action.

 

Please make sure to add value to the To, Subject and Body of the email in the Send an email action, make sure to save the flow, and then run the flow to see if the issue still exists.

 

Please let me know if your problem could be solved.

 

 

Best regards,

Alice

View solution in original post

nd13
Level: Powered On

Re: Email Attachments in Flow

Hi, Alice. 

 

I put values into the To, From, and Subject fields but still have the error. 

Karen-Miller
Level: Powered On

Re: Email Attachments in Flow

Did this ever get resolved as I have had the same issue.

All the fields are completed but I get the same error message.

nd13
Level: Powered On

Re: Email Attachments in Flow

Yes! The issue has been  resolved. The error was in the "Append to array variable" step. Here is what worked: 

Capture.PNG

 

 

Here is the full flow: 
Full Flow.PNG

View solution in original post

AlbertoSP
Level: Powered On

Re:Email Attachments in Flow

I'm getting the same error, but nit sure howe to fixe the array.
Was the a formula used in the expression to get  $content ?

 

 

AlbertoSP
Level: Powered On

Re:Email Attachments in Flow

I'm getting the same error, but nit sure howe to fixe the array.
Was the a formula used in the expression to get  $content ?

 

 

DanShun
Level: Powered On

Re: Re:Email Attachments in Flow

For everyone getting that error, you need:

{
  "Name": @{items('Loop_Through_Attachments')?['DisplayName']},
  "ContentBytes": @{body('Get_attachment_content')?['$content']}
}

when you append to the array. Basically need to add "?['$content']" to the attachment content in the loop.

 

Explination found:

https://www.portiva.nl/nl/portiblog/2018/03/07/send-email-with-multiple-attachments-using-microsoft-...

 

and:

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

741852
Level: Powered On

Re: Email Attachments in Flow

I have been able to send an email attachment using the information discussed, but the attachment comes through as an unidentified file type rather than the file type it was uploaded as (PDF file).

 

Any ideas on how to resolve?

DanShun
Level: Powered On

Re: Email Attachments in Flow

Make sure you have the file type in the name as well. eg. "ImportantDocument.pdf" and not just "ImportantDocument".

 

Download the file that got attached, rename it and add the ".pdf", and if it works that was the issue.

741852
Level: Powered On

Re: Email Attachments in Flow

Thank you for the quick reply. Unfortunately, I tried renaming the file with a ".pdf" and it produced the same results. I'm using Adobe Acrobat Document to open and upload the files so not sure if that makes a difference or not. I've also tried standard Excel documents as well and the results are the same.

Capture.PNG

 

Capture 2.PNG

Any assistance is greatly appreciated. This is the last hurdle before I can operationalize my flow Smiley Happy

DanShun
Level: Powered On

Re: Email Attachments in Flow

Weird, can you screenshot the relevent parts of the flow itself?

741852
Level: Powered On

Re: Email Attachments in Flow

Sure. To provide some context, I am attempting to create a flow that will 1) generate a list item in Sharepoint from a Microsoft Form submission, 2) send that list item (with an attachent link) for approval, and 3) upon receipt on that approval, send the attachment via email to another group within the company. I am manually adding the attachment to the list after the form submission, but before the approval is sent using a delay function (between steps 1 and 2). There are some other time conversion functions in the flow but I believe those can be ignored as they shouldn't impact this output. Please see below for my current flow diagram:InkedInkedCapture_LI.jpgInkedInkedInkedCapture 2_LI.jpgInkedInkedCapture 3_LI.jpgInkedInkedCapture 4_LI.jpgInkedInkedCapture 5_LI.jpgInkedCapture 6_LI.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

The relevant parts of the flow are probably the last 2-3 images.

Highlighted
DanShun
Level: Powered On

Re: Email Attachments in Flow

I think i see the problem, in Append to Array Variable 2, you set the name to Invoice Number. You should add the .pdf extension there.

 

Also is there more than one document? It might cause issues if you have them named the same - but not sure. Does the size of the attachment in the email match with what's in SP?

741852
Level: Powered On

Re: Email Attachments in Flow

I tried to enter the .pdf as you recommended, but was met with an error "enter a valid json".

Capture 12.PNG

 

 

 

 

 

 

 

 

Capture 10.PNG

 

 

 

 

 

 

 

 

Also, I checked about the last comment you made. The file that I attached was 2806 KB, but the file that came through the email was 4MB.

Capture 11.PNG

 

 

Capture 13.PNG

 

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!

Top Kudoed Authors
Users Online
Currently online: 64 members 3,530 guests
Please welcome our newest community members: