Hi!
I'd like to create multiple HTML tables from one array. Let's say that my array looks like below:
[
{
"User": "AAA",
"Project": "Project1",
"TimeSpent": 10
},
{
"User": "AAA",
"Project": "Project2",
"TimeSpent": 20
},
{
"User": "AAA",
"Project": "Project3",
"TimeSpent": 30
},
{
"User": "BBB",
"Project": "Project1",
"TimeSpent": 50
},
{
"User": "BBB",
"Project": "Project3",
"TimeSpent": 10
},
{
"User": "CCC",
"Project": "Project4",
"TimeSpent": 100
},
{
"User": "CCC",
"Project": "Project5",
"TimeSpent": 60
}
]
As a result, I'd like to get 3 tables:
User | Project | TimeSpent |
AAA | Project1 | 10 |
AAA | Project2 | 20 |
AAA | Project3 | 30 |
User | Project | TimeSpent |
BBB | Project1 | 50 |
BBB | Project3 | 10 |
User | Project | TimeSpent |
CCC | Project4 | 100 |
CCC | Project5 | 60 |
Thank you! I was trying something very similar but it didn't work. Your solution works and that's exactly what I was looking for.
Hi @kamil_k ,
Try this:
union(body('Select'),body('Select'))
Result will be the same as before but this process will be dynamic~
Hope this helps!
Community Support Team _ Wenjuan Zou
If this post helps, then please consider Accept it as the solution to help the other members find it.
Thanks for your reply! It will work for this particular array but in my scenario, this array may have multiple records (hundreds of users). Any idea how to deal with it? It will be not possible to use this "static" filtering.
Hi @kamil_k ,
I store your array in a variable and make a simple demo:
Use "Filter array" action to retrieve data whose "User" field is AAA, and "Create HTML table" by its output. Repeat these two actions to create HTML table for BBB and CCC.
Here's how it looks like in a mail:
Hope this helps!
Community Support Team _ Wenjuan Zou
If this post helps, then please consider Accept it as the solution to help the other members find it.
Michael E. Gernaey
179
Super User 2025 Season 1
David_MA
161
Super User 2025 Season 1
stampcoin
143