BannerImageURL - image not displaying in the email

[annahorodecka]

Dear Community

I have created my first Flow to send an email notification the NEWs are posted on the Sharepoint. 

The flow is triggered when the file is created or modified:

The email self has an HTML code which I have copied from a composed and sent to myself email. 

In this code I try to insert Banner Image URL active link to display the picture of the new:

But the email comes like this - the picture is not loading:

What shall I do differently?

[leo85]

Hi @annahorodecka ,

where is your image hosted? Is it a public website? Is it SharePoint?

If you image is small, you can also use base64 encoding to provide the image data directly in HTML.

Regards,

Leo

[annahorodecka]

Dear Leo

my image is a Banner of the NEWs post on Sharepoint:

I would like to keep it dynamic, meaning that the image would change per POST, because obviously, every NEWS post will have a different image. 

If Im correct I can not use base64 encoding for this purpose. 

[leo85]

Where is the image hosted? Please post the link (if possible anonymized).

You cannot use images hosted in SharePoint in emails. Images need to be publicly available, so the email client can load them.

[annahorodecka]

Dear Leo

Im not sure you will be able to access our site. 

It is a Sharepoint:

We are creating content NEWS, the Flow send out the email to the Members of the Community. Email shall pick up the picture used for the NEWS article. I watched the video: https://www.youtube.com/watch?v=24MgEZn6Y7c&t=531s , where BANNER IMAGE URL active code was used for this purpose

[leo85]

I'm sorry. Why are you not helping and providing the information I ask for?

Where is your image hosted? What is the URL that you put in the <img> tag?

I don't want access to your site. I want to know if it is hosted in SharePoint. If the image is hosted in SharePoint, it will not work in your email!

[annahorodecka]

Im sorry, but as you can read this is the first FLOW Ive ever created, Im not an IT person, just a project manager trying to find her way in this new world

I dont put the URL in the <img> tag. I try to put:

at the beginning of the html:

[leo85]

Hi @annahorodecka ,

the "Banner Image URL" is within the <img>-Tag. And you try to put the <img>-Tag at the beginning of your HTML.

As I understand you get the information from a SharePoint document library. This library has got the columns "Banner Image URL", "Title" and "Description".

Please provide the information in the "Banner Image URL" column.

Or provide the output of the failed "send an email" action.

How to get the output?

1. Go to the flow's detail page

2. Click on the latest failed run

3. Click on the "Send an email" action

4. Copy the output

Regards,

Leo

[annahorodecka]

The "send and email" action didnt fail. Email is sent out, but picture in the email comes as a cube with red cross in it...

As to the Sharepoint Document Library, This is the printscreen how I see it.... I was looking for BannerImage URL column.... but there is no such.... I can add HyperLink column but the information if not filled in

[leo85]

Provide the output of the "send an email" action.

How to get the output?

1. Go to the flow's detail page

2. Click on the run which did not work as expected

3. Click on the "Send an email" action

4. Copy the output

[annahorodecka]

Dear Leo

It is solved, thank you for trying to help. 

[leo85]

Hi @annahorodecka ,

great news. Could you please quickly write how you solved the issue, so other users can benefit?

Please afterwards mark the answer as a solution.

Regards,

Leo

[annahorodecka · Accepted solution]

Yes

So how to insert a Banner Image in the email notification about the new NEWS posted on your Sharepoint:

GET FILE CONTENT - picks up the picture (company logo) which is used in the email signature under my name and contact details:

And the most important is the HTML code for the email self. Ive used the advice of formatting the email to my needs, send it to myself and get the HTML code of the email received by: Open the Email --> Actions --> Other actions --> View Source. Copy the code and paste it in the Send Email step:

Tip&Trick:

In the email you are composing, use WELL VISIBLE text which later you want to exchange by active Flow code, eg. 

%%%TITLE%%%

&&&DESCRIPTION&&&&

etc

so when you copy-paste the code you can easily find the text that you exchange:

The trick with Banner Image:

To have your email picking up the picture used for the NEWS article you want to use BannerImageURL code, this is how you insert it in your HTML code:

And TEST 🙂