Attachment corruption on approval emails

[MBach20]

Hello all,

We have created an approval workflow with multiple attachments but we cannot figure out why the attachments don't work once in the the approval email. The screenshot below is the coding which we have used. We tested an approval with 3 attachments; two of them open as blanks and one opens with the error message below. All three attachments are fine when uploaded to the SharePoint list.

Tagging @ChristianAbata as you kindly helped solve my previous workflow issue.

Thank you!

[ChristianAbata]

hi @MBach20  please try adding in your json format the next format

[{"Name":"asdasd.docx","ContentBytes" : "HERE YOUR CONTENT IMAGE"}]

See you have content instead content bytes.

Let me know xD 

[Jay-Encodian]

Hey @MBach20 

Try wrapping the 'File Contents' property in the base64() expression... this will instruct Flow to pass just the base64 $content and not the entire file contents value.

May be of interest - https://blog.encodian.com/2020/07/working-with-file-contents-and-files-in-power-automate/

HTH

Jay

[v-bacao-msft]

Hi @MBach20 ,

If the attachments come from the SharePoint list, you can refer to the following configuration:

Best Regards,

[MBach20]

Hi @ChristianAbata 

Thank you for your reply! 

I understand from previous posts (and have tested this as well) that ContentBytes works for multiple attachments for "send an email", however for approval workflows, the json required is just "Content".

[MBach20]

Hi @Jay-Encodian 

Thank you for your reply - we just gave this a go (hopefully we got it right), however the same error appears;

[MBach20]

Hi @v-bacao-msft 

Thank you for your reply! We copied the exact output you have provided, however the following error appears:

[Jay-Encodian · Accepted solution]

Hey @MBach20 

You only need to add the 'File Contents' property inside the base64() expression... you shouldn't add the $content extra elements.

Anyhow you shouldn't need to do this... I have just tested, see below which works:

HTH

Jay

[MBach20]

Thank you!

[Anonymous]

@Jay-Encodian 

How do I fix this error?

[Jay-Encodian · Accepted solution]

Hey @Anonymous 

Please refer to the post... you are using an incorrect JSON element.

ContentBytes should just be content

This video covers this in detail: https://powerusers.microsoft.com/t5/Webinars-and-Video-Gallery/Add-Multiple-Attachments-to-an-Approval/td-p/748527

HTH

Jay

[tinalamkey]

Jay:  I am having a similar issue, all attachments within the email are corrupt.  Could you help explain what I am doing wrong?