Answered

Sending email with multiple attachments from Sharepoint list

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hoping someone can help, I have created a form in PowerApps which creates a new item in a Sharepoint list when the user submits the form. The form allows the user to attach multiple attachments for which the SharePoint list is updated with the attachments. When an item is created, an approval process is initiated using a Flow where an email is sent to the approver. The problem I am facing is that the email only includes one attachment even though there is more than one attachment.

Categories:

General topics

All responses (10)

Answers (2)

Sort by

Verified answer

Jay-Encodian 2,920 on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @Anonymous
You'll need to retrieve each attachment from the list SP list item, build a JSON array (string variable) containing the attachments.... and then add string variable to the attachments property on the send email action.
This article will have you covered: https://preview.flow.microsoft.com/en-us/blog/multiple-attachments-single-email/
HTH
Jay
-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Tom_Slosse 1,430 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @Anonymous

Just like @Jay-Encodian suggested that should do the trick.

Please let us know if you are stuck on anything.

Kind regards

Tom
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Jay,

Thank you for your suggestion, however, it doesn't seem to work in my situation. I have followed the instructions from the article to the T but no attachments are included in the email, despite there being attachments included in the list item.

I tried a similar approach previously using "Get Attachment" and "Get Attachment Content" but not "Initialize array". Though it did include one attachment with the email, when there were multiple attachments, it only included one.

Any suggestions as to where I've gone wrong?

Many Thanks
Jay-Encodian 2,920 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous
Can you please post some screen shots of your Flow configuration please... all elements
Thanks Jay
Tom_Slosse 1,430 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @Anonymous

Could you please share a screenshot of your Flow and the result you got with your one attachment?

Kind regards

Tom
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

This is the flow that works successfully with one attachment

And this is the flow for multiple attachments

I attempted to run the flow for multi attachments again and now receive the following error message which I don't quite understand as all necessary fields have been provided.
Jay-Encodian 2,920 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @Anonymous
The error message is stating that you need to provide all the input parameters for the email action: Subject, Body and Actions.
Your screen shot shows that the 'Body' property is empty:
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Jay,

The first flow which worked for a single attachment didn't require me to input parameters in those fields so assumed it wasn't compulsory. Anyhow, I did input parameters in the multi attachment but still get the same error message.
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Just to put closure to this issue, I've managed to resolve the problem.

The enable the flow to include multiple attachments to the email, under the 'Append to array variable' - 'value', you need to change the 'contentBytes' to

"ContentBytes": "@body('Get_attachment_content').$content"

Thanks for your help.
JFred131 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Not sure where to post this since the general topic has been answered so many times. Reference the article, I did exactly as it said, but I now receive this strange error:
No input parameters provided. Please provide required input parameters 'To', 'Subject' and 'Body'.
clientRequestId: df93265b-9a4f-419c-817e-04aa9e8fb308

The input parameters are provided correctly. The flow works fine when the attachments array isn't added to the email, the output even looks correct. But as soon as I place the array variable in the attachments, that's what I get. The flow will also work fine with a single attachment rather than the array. I've tried using a variable expression, composing the array first, inputting it just about every way I can think of. Any help would be much appreciated.