Sending email with populated file attachment as well as file from SharePoint

(0) Share

Report

Posted on by MSSAdmin

I have a flow that populates a Word doc and converts it into a PDF.

The data comes from SharePoint which gets it from a form submission in PowerApps.

The user also attaches files in PowerApps which will be stored in the SharePoint list.

I need both the converted PDF file as well as the attachments from SharePoint to the sent with the email.

I have searched the web far and wide but only every found one or the other solution but not both. I am able to either attach the PDF file OR the SharePoint files but not both.

Please help! Thank you.

Screen Shot 2020-10-14 at 2.30.13 pm.png

This is my flow for getting the attachments from SharePoint. If anyone can help, I'm happy to expand and upload more screenshots.

Categories:

Building flows

I have the same question (0)

All responses (16)

Answers (0)

v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @MSSAdmin,

It seems that you have successfully added item attachments to the attachments array. The next thing you need to do is add another Append to array variable action, and add the PDF file to the attachment array.

{ "Name": "@{outputs('Create_file')?['body/Name']}", "ContentBytes": "@{base64(outputs('Convert_Word_Document_to_PDF')?['body'])}" }

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
MSSAdmin 44 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your help.
Unfortunately I still only get the attachments from SharePoint. The flow runs fine, there are no errors, I just don't received the PDF attachment with my email.
I have added an "initialise variable" and "append to array variable" step but I'm also not sure where they should be positioned in my flow.
Please see screenshots below.

Was this reply helpful? Yes No
v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @MSSAdmin,

Because you put PDF file and attachments in two different variables, and I assume that you just put the variable Multiple attachments into the Email, right?

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
MSSAdmin 44 on at

Like (0)

Report
Copy link

Link copied!

There is only one box to add which attachment are added to the email so I added both variables with a ";" and also tried "," and also no comma.
I get the following error message:

Flow save failed with code 'OpenApiOperationParameterValidationFailed' and message 'Input parameter 'emailMessage' validation failed in workflow operation 'Send_an_email_(V2)': The parameter with value '"@{variables('Multiple Attachments')}; @{variables('EmailAttachments')}"' in path 'emailMessage/Attachments' with type/format 'String' is not convertible to type/format 'Array'.'.

Was this reply helpful? Yes No
v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @MSSAdmin,

Please not to do that, you just need to do is delete one of the two variables, then Append the PDF file and Attachments file into a variable at the same time. Then put the variable into the Email, it could work.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
MSSAdmin 44 on at

Like (0)

Report
Copy link

Link copied!

Great it finally worked!
Thank you for your help 🙂

Was this reply helpful? Yes No
MSSAdmin 44 on at

Like (0)

Report
Copy link

Link copied!

I have another question:
When trying to attach more than 1 picture as an attachment, I get sent an email and there are two problems with it:
1) I get sent the two pictures I attached (as it should) but also the filled in PDF twice.
2) I can't open the pictures nor the pdfs that are attached.
The error message for the pdf file is:
Adobe Acrobat Reader could not open 'Draft - Hrunf[2].pdf' because it is either not a supported file type or because the file has been damaged (for example, it was sent as an email attachment and wasn't correctly decoded).

The error message for the photo is:
The file “2E4B625D-218F-4615-AB41-DAC574185066[1].jpg” could not be opened. It may be damaged or use a file format that Preview doesn’t recognise.

Any suggestions on why that happens?

Was this reply helpful? Yes No
v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @MSSAdmin,

You could refer to my first reply, use the base64() function convert the file content into base64 code, and try it again:

{ "Name": "@{outputs('Create_file')?['body/Name']}", "ContentBytes": "@{base64(outputs('Convert_Word_Document_to_PDF')?['body'])}" }

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
MSSAdmin 44 on at

Like (0)

Report
Copy link

Link copied!

I'm getting the following error message when doing that:
Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The action(s) 'Create_file' referenced by 'inputs' in action 'Append_to_array_variable' are not defined in the template.'.'.

Honestly I'm losing my mind over this whole thing. I have tried for several hours almost non-stop to find a solution and all I get is more problems.
I have two flows that are the same, they just get content from two different form submissions in PowerApps/SharePoint. Therefore I copy/pasted one flow and adjusted what was needed for the other
(i.e. SharePoint list name etc).
However they both act differently.
While one doesn't give me any attachments at all, the other one worked a few hours ago but with corrupt attachments and now I'm not even getting an email sent.
This whole time though, the flow works fine. I don't get error messages, only the green "Your flow ran successfully".

Was this reply helpful? Yes No
v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @MSSAdmin,

Thank you for your patience and explanation of the situation.

The error that Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The action(s) 'Create_file' referenced by 'inputs' in action 'Append_to_array_variable' are not defined in the template.'.' is caused by the action name not correct.

I can see that you have renamed the Create file action, so the expression should be corrected to:

{ "Name": "@{outputs('Create_PDF_file')?['body/Name']}", "ContentBytes": "@{base64(outputs('Convert_Word_Document_to_PDF')?['body'])}" }

The reason for the file has been damaged is caused by the send Email action only accept base64 format, so we should force the contents of the file to base64 code in case some file content isn't.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No