Save email body and attached images as PDF to document library

(0) Share

Report

Posted on by shelleyb

193

Hello,

I have a flow that saves emails sent to shared mailbox, extracts elements of the email body , creates a file and updates the file properties based off the info we've extracted.

When we create the file, we have it set to the following:

It saves the body of the email but the attachments are not included.

How do I get the email body and attached images to save as PDF file? I think this might be the best solution but open to suggestions.

Any help is appreciated 🙂

Categories:

Building flows

I have the same question (0)

All responses (11)

Answers (0)

Sort by

v-bofeng-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @shelleyb :

If you need to add the image in the email to the PDF, you need to convert the image to Base64 format.
I provide a way to add all the pictures to the end of the text:

Compose:

concat('data:',outputs('Get_Attachment_(V2)')?['body/contentType'],';base64,',outputs('Get_Attachment_(V2)')?['body/contentBytes'])

Compose2:

concat('<img src="',outputs('Compose'),'">')

Best Regards,

Bof

Was this reply helpful? Yes No
shelleyb 193 on at

Like (0)

Report
Copy link

Link copied!

@v-bofeng-msft thanks for the help, its giving me the following error message:

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

Like (0)

Report
Copy link

Link copied!

Hi @shelleyb :

Could you please show me your flow?

Best Regards,

Bof

Was this reply helpful? Yes No
shelleyb 193 on at

Like (0)

Report
Copy link

Link copied!

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

Like (1)

Report
Copy link

Link copied!

Hi @shelleyb :

I noticed that your flow is not configured according to the solution I provided. This is the reason for the error.

Best Regards,

Bof

Was this reply helpful? Yes No
shelleyb 193 on at

Like (0)

Report
Copy link

Link copied!

Thanks @v-bofeng-msft must have missed the loop element the first time round, I've set the flow up as you directed but now I have an the following error message

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

Like (0)

Report
Copy link

Link copied!

Hi @shelleyb :

It may be that the size of the image exceeds the limit.

Best Regards,

Bof

Was this reply helpful? Yes No
shelleyb 193 on at

Like (0)

Report
Copy link

Link copied!

is there a way to compress the image sizes before converting it to pdf without compromising the image? so the size of the image isn't then an issue?

Was this reply helpful? Yes No
Jay50 58 on at

Like (0)

Report
Copy link

Link copied!

HI @shelleyb ,

Can you please help me with this flow, I have similar requirements,
want to merge email body and attachments into one pdf, can you please suggest me the flow which can help me to achieve this requirements.

Thanks

Was this reply helpful? Yes No
shelleyb 193 on at

Like (0)

Report
Copy link

Link copied!

Hi @Jay50

I've tried a variety of different ways to achieve this - simplest way was using the encodian connector
Converting Emails and Attachments to PDF in Power Automate (encodian.com)
I haven't been able to find a work solution that doesn't use a third party solution unfortunately.

Was this reply helpful? Yes No