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
| Desc: Alien |
| Name |
Value |
| Luke |
4 |
| Chaz |
1 |
| |
|
| Desc: Male |
| Name |
Value |
| Ben |
19 |
| Pip |
99 |
| |
|
| Desc: Mutant |
| Name |
Value |
| Han |
7 |
