How can I add a row in a html table

(0) Share

Report

Posted on by 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:

Categories:

Building flows

Excel for automat...

I have the same question (0)

All responses (8)

Answers (1)

v-yueyun-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No
sam123123123 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
v-yueyun-msft on at

Like (1)

Report
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

Was this reply helpful? Yes No
sam123123123 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
v-yueyun-msft on at

Like (1)

Report

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

Was this reply helpful? Yes No
sam123123123 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

v-yueyun-msft on at

Like (1)

Report

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

Was this reply helpful? Yes No
sam123123123 on at

Like (0)

Report

OK, thanks for the solution!!

Was this reply helpful? Yes No