Power Platform Community Forum Thread Details

Create multiple html tables from array based on matching values

Hello, I am looking for some help on creating a flow that will output multiple html tables in an email, but the tables will be separated based on matching values from the parsed json array. I have been working on this for a few days but cannot get the output right, or any output. I know I will need to use loops + variables to be able to match values and create the multiple tables. Unfortunately, I cannot copy my flow as it contains confidential information. I have created an example array/schema below and the expected/desired output. The matching value = Desc.

****As additional information, I am running a query against a powerBI data set, then parsing the json as shown below. Using ChatGPT, I just run into more problems. Thanks in advance!

Sample parsed json

Content
{
   "DataTable[Name]" "Ben",
"DataTable[Desc]" "Male",
"DataTable[Value] "19"
},
{
   "DataTable[Name]" "Pip",
"DataTable[Desc]" "Male",
"DataTable[Value] "99"
},
{
   "DataTable[Name]" "Chaz",
"DataTable[Desc]" "Alien",
"DataTable[Value] "1"
},
{
   "DataTable[Name]" "Han",
"DataTable[Desc]" "Mutant",
"DataTable[Value] "7"
},
{
   "DataTable[Name]" "Luke",
"DataTable[Desc]" "Alien",
"DataTable[Value] "4"
}

Schema
{
"type": "array",
"items": {
"type": "object",
"properties": {
"DataTable[Name]": {
"type": "string"
},
"DataTable[Desc]": {
"type": "string"
},
"DataTable[Value]": {
"type": "integer"
}
},
"required": [
"DataTable[Name]",
"DataTable[Desc]",
"DataTable[Value]"
]
}
}

Desired Output