SharePoint added PDF Files were Sent corrupted as Email Attachments

[sherif77]

Hello Everyone,

I hope you could assist to resolve the following issue,

I have a SharePoint Library that i need to generate automated Email once a PDF file is added to the library. ( the email will be sent to recipients outside our organization)

I have started my flow from basic Microsoft Template "Send a customized email when a new file is added" though its not working as the PDF files usually were sent corrupted.

Please advice bearing in mind that the PDF files in the SharePoint library were added under column named "Name" which may 

I used so far the following actions 

1. when a new file is created ( properties only}
2. Get file Metadata
3. Get file content
4. get my profile V2
5. send Email V2

Your utmost support on this regards is highly appreciated,

Thank for your usual Support, 🙂

Regards,

Sherif

[sherif77]

Further on the below,

[v-litu-msft]

Hi @sherif77,

Please try to use base64() function convert the file content into base64 format, for example:

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.

[sherif77]

The Flow Checker Doesn't like the expression

 

[v-litu-msft]

Hi @sherif77,

Could you share the configuration?

You could past the following expression directly in the field:

@base64(body('Get_file_content'))

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.

[sherif77]

Hi @v-litu-msft 

Okay now its gibberish flow checker didn't point on any problem with the base 64 expression, however its pointing on the Metadata connector.

Which file identifier I should be using under " Get file Metadata" the documents column is " Name"

[v-litu-msft]

Hi @sherif77,

When you get the file metadata and content, the dynamic content Identifier should be the correct selection to appended in the File identifier field:

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.

[sherif77]

@v-litu-msft 

Thank you it passes the Metadata now I'm getting again the Email with a corrupted PFD file. Any suggestions ?

Reagrds,

Sherif.

[v-litu-msft]

Hi @sherif77,

It's weird, I tested on my side and it works perfectly, how about you use the Get file properties action to try it again?

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.

[sherif77]

@v-litu-msft  

I have tried this one too but its not sending the attachment properly its still corrupted. the error I'm receiving when i open the PDF file is saying "Wrong PDF Decoded"

[sherif77]

@v-litu-msft   any further Solutions here ..

Appreciating your help here