PDFs getting corrupt when sent as an email attachment from a SharePoint List

[Anonymous]

Hello All,

I have created a flow that would get the PDF from a SharePoint Attachment column and send it as an email attachment.

Whenever I try to open the PDF from the email , it gives me PDF is corrupt error . The PDF opens fine from the SharePoint List

Below is the flow

Under ContentBytes , I have used different expressions as given below however the PDFs are getting corrupted

base64(body('Get_attachment_content'))

base64(body('Get_attachment_content').$content)

I have read all the articles pertaining to the topic , However facing the same issues

Any help would be appreciated @ClavinFernandes  @RezaDorrani @ShaneYoung 

Thanks in advance

[annajhaveri]

@Anonymous , please use the Attachments Content directly in the Array as shown in below screenshot

[Anonymous]

@annajhaveri  Thank you for responding

Have tried this but it fails.

Also tried base64(outputs('Get_file_content')?['body']) , no luck

[annajhaveri]

okay thats strange, i did try using Attachment Content and it worked for me. Can you share screenshot of send email action which shows attachment property. 

[Anonymous]

I am not sure why PA changes the contentbytes to AttachmentContent as shown below

Even if I change the ContentBytes to expression, it would fail

Also tried base64(outputs('Get_file_content')?['content']) , no luck

[annajhaveri]

It should work with Attachment Content, i tried with Base64 it doesnt work. Are you testing by using Test function from PA, if yes, can you try actually adding new item or editing existing item and test?

[Anonymous]

I am testing with and without the test option , it still fails

Also the flow triggers for new items only 

[Jay-Encodian · Accepted solution]

Hey @Anonymous 

This has you covered: https://powerusers.microsoft.com/t5/Webinars-and-Video-Gallery/Add-multiple-attachments-to-an-email-in-Power-Automate/td-p/745237

[Anonymous]

@Jay-Encodian Thank you for the help

Would surely check this Tutorial and get back to you 🙂