Unanswered

'Add rows to table' only adds blank rows

(0) Share

Report

Posted on by Community Power Pla...

Hello, I have a problem where I want to add rows from one Excel Table to another Table in another excelsheet. I list the rows in the original table, and all rows are collected. Then I try to add those rows to the destination Table, and the correct number of rows are added, but they are all blank.....

Any help would be deeply appreciated.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sundeep_Malik 6,484 on at

Like (0)

Report

Hey @Anonymous
You are creating a new table in the flow. As it is a new table it does not have any values, that's why it showing blank values.

Or if you are also adding values in that table by some way, then in the destination table, you will have to add some values in each column option.
I hope this helps. If you have any doubts, please reply.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hello Sundeep_Malik, and thank you for your answer. Maybe I left out some vital information:
I have this Excel workbook, that contains data in a range.
I then make that range into a table, with the 'Create Table' flow, so it does contain data.
When I use the 'list the rows in a table', I do get rows with data, I can verify that in the run history.

But when I add the listed rows, the data is empty, but the row info is there.
Why are they empty?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I also added another flow 'Create HTML table', between the 'List rows in Table' and 'Add row to table', just to be absolutely sure that the data is there, and the HTML table was created without any problems.

Was this reply helpful? Yes No