Embedding Sharepoint Images from List of News Post into Email Using Power Automate

[euniceong]

I am trying to create a customised news digest using Power Automate. How can I embed the image banners of a list of Sharepoint News Post into an email for images that are uploaded into Sharepoint?

I used the Get Files (Properties Only) to get the list of News Posts. I am able to use html img src for stock images using BannerUrl variable, but for uploaded images, it does not show. I do not have Power Automate Premium, so not able to use HTTP to retrieve the the image content using BannerURL and to embed it using Base64. Is there any alternative way to get the file path of the image so that I can use the "get file content using path" step to get the image content?

Thanks!

[ekarim2020 · Accepted solution]

I did something similar a while back. I remember that getting and embedding the images were a problem. Some times I just couldn't grab the image due to a HTTP 401 error.  See Sharepoint Webview "Access token not found" Error

You may be able to use the Send an HTTP request to SharePoint to get the images? Here are some extracts from that old flow (I'm sure it can be improved) -  but it may provide some guidance:

See this related post: News notifications to be put out once a day

I hope this helps.

Ellis

[euniceong]

thanks! this is very helpful

[Anonymous]

Hi @ekarim2020! thanks for your help, I am actually looking for such a thing but in my case when I am trying to create the image URL(the first step of your provided solution) it's putting the compose into for-each is there any way to get rid of this for-each.   

[Anonymous]

Hi @ekarim2020 ! I am stuck at a point,  how would you iterate through different images for different news and how are you passing relevant images to that news later?

[ekarim2020]

The original flow is quite old now,  and I think it is too complex for beginners. This was one of the first Power Automate projects I did mainly as a learning exercise.

The first thing to do is to read all your news items (within your date range) from your various SharePoint sites and then produce a simple newsletter with no images. This is the starting point. See:  Solved: Re: News notifications to be put out once a day - Power Platform Community (microsoft.com) whichs gives you the different sections of the the flow and what you need to extracts from each news item: 

After you have a working "Plain Text" newsletter, then look at adding HTML styling and images.

Please also take a look at Create and send a news digest (microsoft.com)

Regards,

Ellis

[Anonymous]

thanks @ekarim2020 for your reply is highly appreciated... Yes, I had gone through that phase... that was working fine. but now I am getting an array of my all images but don't know how to assign each news to its related image. 

[ekarim2020]

The Get items action will return all the news items. One property of the news item is the bannerImageURL (not shown below):

Example: "BannerImageUrl": "https://cdn.hubblecontent.osi.office.net/m365content/publish/6ec62607-74d8-49ea-beb8-50098c04c366/th..."

  

 

Ellis

[Anonymous]

@ekarim2020  thanks for your reply... yes it's working fine now but I am stuck somewhere else... if you can help?... well the problem is that my 'link to item' is not working. here are the outputs of my select, making table and the Html code of my email in the mailbox respectively

I have no idea what I am doing wrong here... kindly take a look at it, if you find the error it would be a great help !!

[ekarim2020]

I couldn't view the HTML as the resolution was too low, but see the following:

 

Ellis

[Anonymous]

but my point is different as I am passing the values through select variables... and of course, it's not clear.. but if you open the image it would be clear...

[ekarim2020]

Please cHeck how you have formatted the A HREF tag. The link needs to be enclosed in quotes.

The image of the HTML code isnt clear, even when viewed after clicking it.

Ellis

[Anonymous]

I put the double quotes but no results... I tried that as well 

[ekarim2020]

Please share the output of the HTML code where the link is included, and what the news item looks like to the end user.  What is the issue? Is it that the hyperlink is in the newsletter but nothing happens if you click on the link? Please check that the HTML is well formatted first.

The Select action will output an array. How are your looping through each news item from the output of Select action, and what expressions are you using to reference each propery of the array?

For testing purposes you can keep things simple and avoid using the Select action for now, then embed the properties directly in to a variable:

If you managed to get the simpler text based newsletter working then the HTML version should also work too as it uses the same code for the links:

Ellis

[Anonymous]

@ekarim2020  thank you soooo much for your time and efforts highly humble... the flow is working fine now hurrrahhh!!

[ekarim2020]

Hi @Anonymous,

That's good news!

What changes did you make to get it working? Please post as this info will valubale to others reading these posts in the future.

Regards,

Ellis

[Anonymous]

Thanks... yes sure. 

well, I just wrote this part '<a href ="link">' again in the append variable action which I showed earlier in the image... I did it by copying the code from the peek code of the action and ran it again... so it's working fine