Email Attachments in Flow

[Anonymous]

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:

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

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).

[rookie]

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.

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

[v-yuazh-msft]

Hi @Anonymous,

Have your problem been solved?

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

 

Please let me know if your problem could be solved.

Best regards,

Alice

[Anonymous]

I attached the Attachment Array as you showed:

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

Am I skipping a step or missing something?

[v-yuazh-msft]

Hi @Anonymous,

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.

Best regards,

Alice

[Anonymous]

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. 

[v-yuazh-msft · Accepted solution]

Hi @Anonymous,

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

[Anonymous]

Hi, Alice. 

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

[Karen-Miller]

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

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

[Anonymous · Accepted solution]

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

Here is the full flow: 

[AlbertoSP]

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]

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 ?

[Anonymous]

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]

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?

[Anonymous]

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]

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.

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

[Anonymous]

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

[741852]

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:

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

[Anonymous]

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]

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

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.