Problem with "Add a row into a table" for a transposed HTML table

(0) Share

Report

Posted on by ashraf999

Hello all,

I have created a transposed HTML table that looks like the following:

My problem is populating the excel table in worksheet , "testing.xlsx", that I created with this data. The dates may change depending on the source data so the number of the date columns, 2024-07, 2024-08, etc. is not fixed. They change over time

I tried to use "Add Rows into a table" but I am stuck here. Only one row of the "Portfolio" names is populated without "Count". The table should look exactly like the first image posted earlier

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

lbendlin 8,474 Super User 2025 Season 2 on at

Like (0)

Report

Use the untransposed data to write to Excel. Otherwise you would have to include code to delete and recreate the table headers every time.

Was this reply helpful? Yes No
ashraf999 21 on at

Like (0)

Report

Which code or tool can I use to delete and recreate the table headers every time?

Was this reply helpful? Yes No
lbendlin 8,474 Super User 2025 Season 2 on at

Like (0)

Report

You do that via Graph API calls.

Was this reply helpful? Yes No
ashraf999 21 on at

Like (0)

Report

Is there a simpler way to do it by Office Scripts ?

Was this reply helpful? Yes No