Embed sharepoint list attachment as html in email

(0) Share

Report

Posted on by ccqn

205

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.

Categories:

Building flows

I have the same question (0)

All responses (13)

Answers (0)

v-yetonggu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Manish Solanki 15,167 Moderator on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
ccqn 205 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-yetonggu-msft ,

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

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

Like (0)

Report
Copy link

Link copied!

Hi @ccqn ,

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

Please try this expression:

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
ccqn 205 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-yetonggu-msft ,
Have changed it to
but still not showing up in my email.

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

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
ccqn 205 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-yetonggu-msft ,

The expression still returns a blank

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

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
ccqn 205 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Manish Solanki 15,167 Moderator on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No