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

Eunice 1 Reputation point
2021-08-10T09:13:00.44+00:00

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!

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,523 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Miguel Escobar 326 Reputation points
    2021-09-06T02:38:15.01+00:00

    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!

    0 comments No comments