Saving embedded email images to SharePoint list

(0) Share

Report

Posted on by sudosaurus

1,599 Super User 2024 Season 1

Hello,

I know this topic keeps on coming up - Id like to save embedded images in the body of an email to a SharePoint list item.

I saw somewhere else that @karas had suggested they had done this:

Suddenly I find out that for emails with attachments flow saves embedded images as stand-alone file.

So, I transformed my flow to following:

Export email -> for each attachment - save to list item.

IDK how, but "Export email" action makes MS flow recognize all embedded images as attached files.

https://ideas.powerautomate.com/d365community/idea/09d21571-aca9-4b6d-9614-2737a87ac6c5

This is my flow, however I'm unsure what they mean about doing after the 'Export email' action??

I have used another method where I convert the body to html and use base64 conversion however this is limited to 2mb file sizes.
So Id prefer to get this working another way if even possible?

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @sudosaurus ,

Based on your description, I have made a simple test for your reference.

This my test email:

This is my flow:

You could use the "Get Attachment" action in outlook to get images and then convert them from Base64 to binary. No 2MB limit found.

Or you can use the "Export email" action to save the attachments of the entire email as files, but the file extension should be ".eml".

Result:

Best regards,

Was this reply helpful? Yes No
sudosaurus 1,599 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-jefferni - What was the exact Base64ToBinary expression you used?

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

Like
a
(0)

Report
Copy link

Link copied!
Hi @sudosaurus ,

Expression:

base64ToBinary(outputs('Get_Attachment_(V2)')?['body/contentBytes'])

But actually, if use content bytes from get attachment action directly, I can create attachments for the entry as well.

Best regards,

Was this reply helpful? Yes No
sudosaurus 1,599 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-jefferni

The image doesn't display for me?

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

Like
a
(0)

Report
Copy link

Link copied!

Hi @sudosaurus ,

This Email column is a multiple lines of text column. Attachments will be saved in Attachments column.

Best regards,

Was this reply helpful? Yes No
sudosaurus 1,599 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-jefferni

This is working now thanks!

I noticed that if I take photos and add them to the email body on my phone, the images don't retain their original filename when being processed by the flow.

The first image is added as image.jpeg however any further embedded images are not added because they're also trying to be added as images.jpeg

Before being sent in my email they're formatted as image_4567.jpg so I'm unsure what to do there??

Was this reply helpful? Yes No