Send Multiple SharePoint Images to Email from SharePoint in HTML Table with Power Automate

Опубликовано: 27 Декабрь 2024
на канале: Andrew Hess

6,343

This idea came to me from a coworker who was making a beautiful table and sending a report of items every week on Monday using Power Automate. We couldn't pull in that image column into the HTML table from SharePoint.

In order to pull in that image column we used a HTTP request and Parse JSON to retrieve the image. Finally we manually built an HTML table and wrote it to our SharePoint.

A normal HTML step for me currently at this time did not work, it would not use the base64 output for the image. Maybe things will change in the future, but for now check out this Power Automate Flow we built using a manually created HTML Table and Parse JSON from a SharePoint list.

Formulas:
_api/Lists/getbytitle('MyImageList')/items(@{items('Apply_to_each')?['ID']})

encodeUriComponent(replace(body('Parse_Image_JSON')?['serverRelativeUrl'],'/sites/TaskList',''))

codebracket: img width="100" height="100" src="data:image/png;base64, base64(outputs('Get_file_content')?['body'])"/ :codebracket

Site that had CSS code:
https://ryanmaclean365.com/2020/01/29...

Chapters:
0:00 Introduction
0:30 Part 1: Send Image to Email
1:50 HTTP Request to retrieve Image Column
3:00 Generate Schema for Parse JSON
6:10 Get File Content for Image using encodeUriComponent
7:30 Send Myself Test Email
9:00 Part 2: Build HTML table for Images and send to Email
11:30 Initialize Variable to use to Loop through Rows of SharePoint
14:30 Resize the Images in Compose HTML
15:32 View Message Source of Email