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

Question

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!

Answer 1

Hey!
I'd highly recommend that you post this question on the official Microsoft Power Automate forum, specifically in the "Building Flows" category.

You thread was originally posted in the "Power Query" forum which is a different product. You can learn more about Power Query from the official documentation using the link below:
power-query-what-is-power-query

Best!