Sending email with multiple attachments from Sharepoint list

[Anonymous]

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.   

[Jay-Encodian · Accepted solution]

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]

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

[Anonymous]

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]

Hi @Anonymous 

Can you please post some screen shots of your Flow configuration please... all elements

Thanks Jay

[Tom_Slosse]

Hey @Anonymous 

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

Kind regards

Tom

[Anonymous]

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]

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:

[Anonymous]

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.

[Anonymous · Accepted solution]

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.