Answered

.pdf's not opening after automating an email

(0) Share

Report

Posted on by WilkinsLuke6

Hi everyone, I have set up a flow to send 2 attachments gathered from a Sharepoint list, however when recieving these attachments, I cannot actually open the documents themselves and I'm getting an error that says 'We cant open this file'

I have tried multiple send email flows even with 1 attachment and I still cannot open the files which leads me to think its an issue with 'Send Email V2' and .pdf documents.

My send email flow runs as followed:

Any help would be greatly appreciated!

Categories:

Using flows

I have the same question (0)

All responses (7)

Answers (1)

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

@WilkinsLuke6

You are passing name from Get file content. you should use 'Get File Metadata' Action then use dynamic name from this action.

Thanks

Hardesh

Was this reply helpful? Yes No
Verified answer

CFernandes 8,402 Most Valuable Professional on at

Like (0)

Report
Hi @WilkinsLuke6

You can directly pass the File-content.

{ "Name": @{items('Apply_to_each')?['DisplayName']}, "ContentBytes": @{outputs('Get_file_content')?['body']} }

Screenshot of the full sample Power Automate solution:

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
WilkinsLuke6 25 on at

Like (0)

Report

Hi thanks for your reply,
I have tried putting this bit of code on my 'append to array' function but I seem to get an 'invalid' JSON error. I have tried manually inputting this code through expressions, without expressions and copying and pasting directly. These are the outcomes:

Sorry if I am missing something obvious here but I cant seem to work it out!

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

@WilkinsLuke6

Instead of body in second action VarArray put 'file content' from get file content.

Thanks

Hardesh

Was this reply helpful? Yes No
CFernandes 8,402 Most Valuable Professional on at

Like (0)

Report

Hi @WilkinsLuke6

Please have a close look at my screenshot below:

The 'File Content' is the Output of the 'Get File Content' action.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
WilkinsLuke6 25 on at

Like (0)

Report

Perfect, it seems to be working fine now, I think the issue was, that I was using 'Get attachment content' over 'Get file content'.

Thanks guys for your fast responses 😀

Was this reply helpful? Yes No
CFernandes 8,402 Most Valuable Professional on at

Like (0)

Report

@WilkinsLuke6 I am glad that your problem has been resolved.

Was this reply helpful? Yes No