Embed sharepoint list attachment as html in email

[ccqn]

Hi all,

I am trying to embed some images from Sharepoint list as into my email. Have referred to a few posts but my images are still showing up as blanks. Below is how my flow currently look like

Have tried both get attachment content & get file content and while it returns something, the picture is not showing up in me email.

[v-yetonggu-msft]

Hi @ccqn ,

You don't need the get file content control, please delete it.
Replace the dataUri formula with the formula I provided you.

I did a test for your reference.

In my scenario:

The Result:

My Flow:

<img src="data&colon;image/@{body('Get_attachment_content')['$content-type']};base64,@{body('Get_attachment_content')['$content']}" alt="GG">

Best Regards,

Sunshine Gu

[ManishSolanki]

Hi @ccqn 

Alternatively, use the below expression with dataUri function:

<img src='@{dataUri(outputs('Get_attachment_content')?['body'])}'>

Pls just copy & paste the above expression in the flow.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

[ccqn]

Hi @v-yetonggu-msft ,

For some reason I'm still getting blanks even though the get_attachment_content is returning something

[v-yetonggu-msft]

Hi @ccqn ,

Please delete 'colon' and replace ';' to ':'.

Please try this expression:

Best Regards,

Sunshine Gu

[ccqn]

Hi @v-yetonggu-msft ,

Have changed it to 

 but still not showing up in my email.

[v-yetonggu-msft]

Hi @ccqn ,

Please delete 'image/'.

Please try this expression again:

<img src="data:@{body('Get_attachment_content')['$content-type']};base64,@{body('Get_attachment_content')['$content']}" alt="GG">

Best Regards,

Sunshine Gu

[ccqn]

Hi @v-yetonggu-msft ,

The expression still returns a blank

[v-yetonggu-msft]

Hi @ccqn ,

I'm surprised why your pictures can't be displayed because I used the same method as you.

Could you please create a simple flow like mine, without other controls and html formats, just to check whether attachments in SharePoint can be embedded in the email body?

<img src="data:@{body('Get_attachment_content')['$content-type']};base64,@{body('Get_attachment_content')['$content']}" alt="GG"> 

I know this is a silly question, just to make sure your attachment can be opened in the SharePoint list, right?

Best Regards,

Sunshine Gu

[ccqn]

Hi @v-yetonggu-msft 

Just tried without any other controls and html format and I still can't embed any image. I can open the image from Sharepoint. Not sure if this will help but this is how I attached the image from Microsoft Forms to Sharepoint.

[ManishSolanki]

Hi @ccqn 

Its look like attachment file size issue.

I faced the same issue on embedding gif image with around 1 MB in size, but the same flow worked for smaller gifs:

Solved: Re: Add GIF image into the email body - Power Platform Community (microsoft.com)

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

[ccqn]

Hi @ManishSolanki ,

That could be the problem as the image is 2mb big. Is there any way I could compress it?

[ManishSolanki]

Hi @ccqn 

I don't have the sample ready, but I have learnt it from a legend @mdevaney.

In his blog, Matthew has nicely explained three methods for the same use case:

3 Ways Power Automate Can Embed An Image In Email (matthewdevaney.com)

Thank you @mdevaney for sharing such a valuable content 🙏

[Jim8]

thank you so much, I've been working this for 3 hrs !