Unanswered

Add row into table does nothing

(1) Share

Report

Posted on by Community Power Pla...

As the title specifies.

It does not give an error (Your flow ran successfully, everything looks green) but then it doesn't add anything into the excel file.

I've tried to create a temporal flow to test the functionality and it works.

I've checked the flow because the data is coming from a Form but everything looks good:

(edited the form fields and values)

{

"host": {

"connectionReferenceName": "shared_excelonlinebusiness",

"operationId": "AddRowV2"

"parameters": {

"source": "me",

"drive": "b!mUAt9RjbNUaTDM2tdzZkJaXcDTQFd5xDsASXjy9SGO5kMpY6UWW8R7EDpFSjIgSh",

"file": "01II4XRKWFOIMXSCWCFVCLW2AWBBEKPSSU",

"table": "{64FF7992-9ACC-47BE-B2F2-D1928FA12A52}",

"item/(1)": (value),

"item/(2)": (value),

etc,

}

So, how do I debug what's going on? I've already moved the excel file somewhere else and modified the flow accordingly.

The worst thing is, I'm pretty sure this worked last week 😕

Categories:

Building flows

I have the same question (1)

All responses (5)

Answers (0)

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Anonymous

could you show which values you are entering in excel,

use compose function to check the values you are entering to excel to see what values are returned 🙂

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

Like (0)

Report

The excel is filled with data submitted through a form.

I used a compose and can confirm the data from the form gets there but, for some reason, is not adding the row.

The input and output on the "add row" show the correct values, but the excel doesn't show anything done in the history.
I can tell I have permissions on the file because one of the processes does modify a cell on another sheet from the same document through a excel script, and that works.

Any other test I could do to find out why is not doing anything?

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Anonymous

If data is correctly added from forms to excel, it should have populated there.

Would it be a problem with excel not showing values?

I think this link may help you on that
https://www.stellarinfo.com/article/excel-not-showing-data-in-cells.php

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

Like (0)

Report

I think that's not the case, even if the changes were hidden I should see them in the "recent changes" tab.

My flow reads a value from a list, runs a vlookup which modifies a cell and after a few more steps should add the row.
I see the change done with the vlookup but I don't see the row being added.

I created a temporary flow to just add a row without any operation and could see it on the recent changes tab so, for some reason, the add row inside the more ellaborated flow is not doing anything and I can't see why.

Was this reply helpful? Yes No
CU29070002-0 7 on at

Like (0)

Report

In my case, the row was appended to the very bottom of the table. I initially though you had to create a table with empty lines, but it turns out that "Add row to table" appends to the last line.

SOLUTION: Make the table have only the headers and it will start adding from the top pointing down.

1 people found this reply helpful.

Was this reply helpful? Yes No