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,551 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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

Was this reply helpful? Yes No
lbendlin 8,551 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

You do that via Graph API calls.

Was this reply helpful? Yes No
ashraf999 21 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No