Send Multiple SharePoint Images to Email from SharePoint in HTML Table with Power Automate
Jul 15, 2023 1:00 AM

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

External YouTube Channel

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.

The idea of sending multiple SharePoint images to email from SharePoint in an HTML table with Power Automate is discussed in this text. It originated from a coworker who was using Power Automate to create a stunning table and send a weekly items report every Monday. However, we were unable to incorporate the image column from SharePoint into the HTML table. A HTTP request and Parse JSON were used to retrieve the image and we manually constructed an HTML table, which we then transferred to our SharePoint. Normal HTML steps were unhelpful at the time because they would not utilise the image's base64 output.

  • The Power Automate Flow was built using a manually created HTML table and Parse JSON from a SharePoint list.
  • The image was encoded with a formula: api/Lists/getbytitle('MyImageList')/items(@{items('Applyto_each')?['ID']}).
  • Body content was used to replace the 'serverRelativeUrl'.
  • An image tag with width and height attributes was used to display the image.
  • A data URL scheme was used for embedding the image in the HTML.

Digging Deeper into the Topic

This method can be beneficial for a number of activities involving SharePoint and emailing. The approach to implementing an HTML table using Power Automate is efficient and accommodates a wide range of data types, including SharePoint images. The key is properly using HTTP requests and Parse JSON to retrieve the necessary image data. This allows sending comprehensive reports with visuals, increasing the effectiveness of communication.

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

Microsoft Power Automate is a powerful tool that allows users to automate tasks and workflows. This article discusses how to use the Power Automate to send multiple SharePoint images to an email in an HTML table. The process involves using a HTTP request and Parse JSON to retrieve the images, and then manually building an HTML table and writing it to SharePoint. It is also necessary to use the encodeUriComponent and replace functions, as well as a CSS code bracket. Power Automate can be a great timesaver when it comes to automating tasks with SharePoint images.

More links on about Send Multiple SharePoint Images to Email from SharePoint in HTML Table with Power Automate

Posting an Image on an HTML Table for an E-mail update
Jun 28, 2022 — Solved: Hi - I am creating a SharePoint site that functions as a marketplace, and I am trying to figure out how to create a weekly ...
Add images to email messages - Power Automate
Apr 5, 2023 — Power Automate enables users to include images in their emails by attaching them or embedding them to the email body. Send images as email ...
Embed multiple images in email - Power Platform Community
Aug 1, 2021 · 2 postsI have a flow that creates a Microsoft List item from a form response. The form has 10 separate image upload items with up to 3 images per item.
Solved: Attaching Multiple Images from a Sharepoint to an
Jan 20, 2021 — Solved: I have an app that is capturing an image, saving it to a SharePoint and then sending an email with that image.
Multiple Tables from One SharePoint List Send Individual Emails
Mar 25, 2023 — Solved: In my SP Event List: Event Date, Company Name, Mngr Email. How would I send an email to each manager that created the event broken ...
Embed images in email report via Power Automate | Medium
Apr 14, 2021 — Under Site Address, select your SharePoint site and for File Path, under Dynamic Content, select AbsoluteUri which is the link to the attachment ...
Power Automate - Embed 2 images within an email
Oct 30, 2022 — I was able to successfully embed an image into a Power Automate email utilizing "Get File Content", "Compose" (with this expression base64(body ...
Power Automate flow HTML Table Formatting in Email
Step-by-step tutorial on creating HTML tables using flows and ✉️ emailing the table data. Covers various filter query scenarios with SharePoint lists, ...

Keywords

Send SharePoint Images by Email with Power Automate, SharePoint Image Column in HTML Table, HTTP Request and Parse JSON, Manual HTML Table, Power Automate Flow, EncodeUriComponent, Replace, Get File Content, Base64 Output.