How to add Group Headers to an email sent from Logic App in Azure

Question

I need to send an email from Logic App in Azure
I have a SQL DB recordset to be rendered as a html table to message body, e.g.:

Group1 Name1 Value1
Group1 Name2 Value2
Group1 Name3 Value3
Group2 Name4 Value4

...

I need to render it into smth like this in html table in email:

Group1
Name1 Value1

Name2 Value2

Name3 Value3

Group2

Name4 Value4

how to do it?

Answer 1

@Azurin4848484 You need to use the above as inline code for the example that Sedat has shared. If you don't want to use the inline query, then you need to use loop to iterate it and build your custom HTML string by using append to variable.

Alternative you can also offload this functionality to a function app callling it from logic app that would have your custom logic to build the required string as per your business need.

Answer 2

assume your SQL query provides data like

let data = [
    { group: "Group1", name: "Name1", value: "Value1" },
    { group: "Group1", name: "Name2", value: "Value2" },
    { group: "Group1", name: "Name3", value: "Value3" },
    { group: "Group2", name: "Name4", value: "Value4" } 
    // ... more data
];

how you could construct the HTML table

let htmlTable = "<table>";
let currentGroup = "";

for (let item of data) {
    if (item.group !== currentGroup) {
        htmlTable += `<tr><th colspan="3">${item.group}</th></tr>`; 
        currentGroup = item.group;
    }
    htmlTable += `<tr><td>${item.name}</td><td>${item.value}</td></tr>`;
}

htmlTable += "</table>";

// ... (Use the htmlTable variable in your email action)