Send weekly email from SharePoint list with embedded image based on date column

(1) Share

Report

Posted on by NG-24021609-0

Hello,

I've been working on setting up a Power Automate flow to send out an email every Monday with a different image based on a list. The list has an image column and a date column. The email should send based on the date column and embed the image from the image column. The email flow seems to be working fine, but the image will not embed.

Categories:

Building flows

flow.png

3-compose.png

4-sendemail.png

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

David_MA 12,982 Super User 2025 Season 2 on at

Like (1)

Report
You cannot just put the URL to the file in the e-mail. You need to embed the image. To do that, do the following:

Use the Get file content using path and point it to the image you want to embed.

Put the e-mail action into HTML mode and enter this: <img src="@{dataUri(body('Get_file_content_using_path'))}" />

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 53,414 Super User 2025 Season 2 on at

Like (1)

Report

Hi @NG-24021609-0

Please go into the flow run (not the editor), look at a flow that completed. Go to the Email Action and review the content it sent out.

If you are using HTML for the email you can even do a view source in your email.

the goal is to see the value itself, because you spoke of Embedding it, but you aren't embedding, you are linking to it, so you have to make sure the link is accurate AND that the people are allowed to get to that SharePoint site and list, after they get the email. So if the link works for you AND the email source looks good. Ask them to copy out the link and just try in their browser and see if they get errors.,

Was this reply helpful? Yes No
NG-24021609-0 2 on at

Like (0)

Report
"Put the e-mail action into HTML mode and enter this: <img src="@{dataUri(body('Get_file_content_using_path'))}" />

When i do this, i get an error message "The input parameter(s) of action 'Send_an_email_(V2)' contain an invalid reference to 'Get_file_content_using_path'. Correct to include a valid reference to 'Get_file_content_using_path' for the input parameter(s) of action 'Send_an_email_(V2)'.

Was this reply helpful? Yes No