How can I add a row in a html table

[sam123123123]

Hello all,

I have a flow already that generates an HTML table. However, I am stuck in adding a row for the table. 

Hope can get some help.

Desirable HTML table

Excel table:

Current flow:

[v-yueyun-msft]

Hi, @sam123123123 

If you want to insert a row in "Create html table", then you need to merge the two arrays. You'll need to create your total row as an array yourself. Then merge the two arrays, and finally create the HTML table.

Best Regards,

Yueyun Zhang

[sam123123123]

Hello Yueyun Zhang,

Nice to see you again. Is it possible that you do a small demo or provide a sample flow that I can use it for my flow. Really appreciate!

[v-yueyun-msft]

Hi , @sam123123123 

Thanks for your response! For example , this is an test array created by the "Initialize variable":

[
                {
                    "Document Date": "2023/02/12",
                    "Due date": "2023/02/20",
                    "Balance": 100,
                    "0-30": 150,
                    "31-60": 120
                },
                {
                    "Document Date": "2023/02/13",
                    "Due date": "2023/02/21",
                    "Balance": 50,
                    "0-30": 120,
                    "31-60": 320
                },
                {
                    "Document Date": "2023/02/14",
                    "Due date": "2023/02/22",
                    "Balance": 120,
                    "0-30": 250,
                    "31-60": 220
                }
            ]

This is my test flow:

xml(json(concat('{"root":{"item":',variables('DataTest') ,'}}')))

xpath(outputs('Compose'), 'sum(/root/item/Balance)')

xpath(outputs('Compose'), 'sum(/root/item/_x0030_-30)')

xpath(outputs('Compose'), 'sum(/root/item/_x0033_1-60)')

union(outputs('Compose_2'),variables('DataTest'))

And you need to test it in your side and replace the action name and the field name in your side.

Best Regards,

Yueyun Zhang

[sam123123123]

Hello Yueyun Zhang,

Thanks for the solution. It seems like your solution is summing up all the numbers, which I think it will be useful in the future, but I am stuck in designing the HTML table like the below picture. I am wondering how to insert a "Total" row in a HTML table. Thanks!

[v-yueyun-msft]

Hi , @sam123123123 

In my understand , this is the total row.

And if you want to update the html table , you can see the output of the "Create html table" action:

    "body": "<table><thead><tr><th>Document Date</th><th>Due date</th><th>Balance</th><th>0-30</th><th>31-60</th></tr></thead><tbody><tr><td></td><td></td><td>270</td><td>520</td><td>660</td></tr><tr><td>2023/02/12</td><td>2023/02/20</td><td>100</td><td>150</td><td>120</td></tr><tr><td>2023/02/13</td><td>2023/02/21</td><td>50</td><td>120</td><td>320</td></tr><tr><td>2023/02/14</td><td>2023/02/22</td><td>120</td><td>250</td><td>220</td></tr></tbody></table>"

If you want to update this html , you can refer to this html code and find where you need to add some rows.

And you can test the html code in w3school.

W3Schools Tryit Editor

Best Regards,

Yueyun Zhang

[sam123123123]

Hi Yueyun Zhang,

I think I should say column. And then the table is a two-dimensional table instead of one. Sorry for the confusion.

[v-yueyun-msft · Accepted solution]

Hi, @sam123123123 

Thanks for your response! Do you mean you want to add a column in a html table. If this , you can union this array:

union(outputs('Compose_2'),variables('DataTest'))

The result is as follows:

And in my understand, there is no method to create a two-dimension table using the "Create html table" action.

Best Regards,

Yueyun Zhang

[sam123123123]

OK, thanks for the solution!!