Solved: Posting an Image on an HTML Table for an E-mail up...

yoshtrich · ‎06-28-2022

Hi -

I am creating a SharePoint site that functions as a marketplace, and I am trying to figure out how to create a weekly newsletter to update people about items that were posted in the past week. I've constructed a flow that sends an HTML table to a specified list of people every week, but I am struggling to upload the associated Item Picture on the HTML file. When the email sends, all the text is present, but there is no image.

Any idea how to remedy this?

Thanks,

Josh

v-yujincui-msft · ‎07-01-2022

Hi @yoshtrich ,

Do you have a Image Column in your SharePoint list?

Maybe you could check the OUTPUTS of Get Items Action, the value of Thumbnail should be null.

If you want to send the pictures in the Image column to the mail, i have made a simple test for your reference.

Here is my Flow.

_api/web/Lists/getByTitle('Testlist')/items()?$select=ItemPic,Title

json(items('Apply_to_each')?['ItemPic'])?['fileName']

concat('/SiteAssets/Lists/foldername/',outputs('Compose'))

body('Get_file_content_using_path')?['$content']

<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>

<table>
<tr>
   <th>Title</th>
   <th>ItemPic</th>
</tr>
@{variables('varhtmltable')}
</table>

</body>
</html>

Result Screenshot:

In addition, here are some links that might help you:

https://powerusers.microsoft.com/t5/Using-Connectors/Unable-to-Use-Image-Field-in-Microsoft-List-to-...

https://powerusers.microsoft.com/t5/Building-Flows/Embed-image-into-automated-email-from-Sharepoint-...

https://powerusers.microsoft.com/t5/Building-Flows/Convert-a-JPG-received-by-email-in-PDF-and-send-a...

https://powerusers.microsoft.com/t5/Building-Flows/HTML-format-in-table/m-p/1640451#M182411

Best Regards,
Charlie Choi

View solution in original post

v-yujincui-msft · ‎07-01-2022

Hi @yoshtrich ,

Do you have a Image Column in your SharePoint list?

Maybe you could check the OUTPUTS of Get Items Action, the value of Thumbnail should be null.

If you want to send the pictures in the Image column to the mail, i have made a simple test for your reference.

Here is my Flow.

_api/web/Lists/getByTitle('Testlist')/items()?$select=ItemPic,Title

json(items('Apply_to_each')?['ItemPic'])?['fileName']

concat('/SiteAssets/Lists/foldername/',outputs('Compose'))

body('Get_file_content_using_path')?['$content']

<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>

<table>
<tr>
   <th>Title</th>
   <th>ItemPic</th>
</tr>
@{variables('varhtmltable')}
</table>

</body>
</html>