Power Automate | Dynamic HTML Table with Image Column

on


Creating a Dynamic HTML Table and PDF Document Generation Flow in Power Automate 


Introduction: 

Power Automate empowers users to automate workflows seamlessly across various applications and services. In this tutorial, we'll guide you through the creation of a dynamic flow that generates an HTML table with images from Dataverse and converts it into a PDF document. Although the flow showcases six images, we will focus on one image for simplicity.


Prerequisites:

  1. Power Automate account.
  2. Access to a Dataverse environment with the necessary entities.
  3. A OneDrive for Business account for PDF document storage.


Steps:


Step 1: Create a New Flow

  • Log in to Power Automate and initiate a new flow.
  • Choose the "Instant - from blank" template for a manual trigger.

Step 2: Define Trigger

  • Add a "Manual" trigger and configure it to receive a text input, representing the key to query Dataverse records.
  • Define the schema with a "text" property.


Step 3: Connect to Dataverse

  • Add an action to list records from Dataverse using the "OpenApiConnection" type.
  • Configure the connection to the Common Data Service for Apps.


Step 4: Initialize Variables

  • Add an action to initialize a string variable to store HTML content.


Step 5: Loop through Dataverse Records

  • Add a "Foreach" action to iterate through the Dataverse records obtained.
  • Inside the loop, append HTML content for each record to the variable.

Step 6: Append HTML Table records to the string variable

  • Add a "Append to string variable" action to iterate & append the Dataverse records obtained.



Input:

<tr> <td>@{items('Apply_to_each')?['cr484_checklistcode']}</td> <td>@{items('Apply_to_each')?['cr484_task']}</td> <td>@{items('Apply_to_each')?['cr484_header']}</td> <!-- Additional columns for other fields --> <td><img height="50" src="data:image/jpeg;base64,@{items('Apply_to_each')?['cr484_uploadimage']}" width="80"></td> <!-- Additional image columns --> </tr>


Step 6: Define HTML Table 

  • Add a "Compose" action to define the HTML table structure with headings and the appended content.

  • "Compose" action responsible for creating the HTML structure that defines the table headings. Let's break down this action to understand its purpose and the HTML code it generates.





Input:

<html> <body> <style> table { border-collapse: separate; border-spacing: 0;; width:100%; } th, td { padding: 8px 15px; border-right: 2px solid #000; border-bottom: 2px solid #000; } th:first-child, td:first-child { border-left: 2px solid #000; } th { background-color: #ddd; border-top: 2px solid #000; } th:first-child { border-top-left-radius: 8px; } th:last-child { border-top-right-radius: 8px; } tr:last-child td:first-child { border-bottom-left-radius: 8px; } tr:last-child td:last-child { border-bottom-right-radius: 8px; } </style> <center> <table> <tr> <th>Code</th> <th>Task</th> <th>Header</th> <th>InspectionImage1</th>
<!-- Additional Table Headings here -->
</tr> <!-- Dynamic html generated in the variable will be used here --> </table> </center> </body> </html>

Step 7: Create HTML File

  • Add an action to create an HTML file in OneDrive for Business using the "CreateFile" operation.


Step 8: Convert HTML to PDF

  • Add an action to convert the created HTML file to a PDF.


Step 9: Create PDF File

  • Add an action to create the final PDF file in OneDrive for Business.


Output of the Document Generated by Flow:



Conclusion: This Power Automate flow dynamically generates an HTML table with images from Dataverse and converts it into a PDF document. Customize the flow to fit your specific requirements, handling multiple images and additional data from Dataverse.


Comments

  1. AnonymousMarch 12, 2024 at 12:56 AM

    how to handle the large photo size?

    ReplyDelete
  2. AnonymousJanuary 8, 2025 at 11:01 PM

    Transforming JSON data in Azure Data Factory can seem complicated, but it’s crucial for making data work better. At Datatera.ai, we make this easy for everyone, even if you’re not tech-savvy. Our user-friendly platform helps you manage and transform data effortlessly, saving you time and hassle. Explore Datatera.ai today!

    ReplyDelete

Post a Comment