How to create multiple HTML tables from one array

Like (0) Share

Report

Posted on 24 May 2023 13:24:20 by kamil_k

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

All responses (4)

Answers (2)

kamil_k 14 on 30 May 2023 at 10:55:16

Like (1)

Report

Re: How to create multiple HTML tables from one array

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.
Verified answer

v-wenjuan-msft Microsoft Employee on 26 May 2023 at 01:53:31

Like (0)

Report
Re: How to create multiple HTML tables from one array

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.
kamil_k 14 on 25 May 2023 at 15:35:09

Like (0)

Report

Re: How to create multiple HTML tables from one array

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.
Verified answer

v-wenjuan-msft Microsoft Employee on 25 May 2023 at 07:00:29

Like (0)

Report

Re: How to create multiple HTML tables from one array

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.