Different tables having rows added when forms submitted

(0) Share

Report

Posted on by GA-06052302-0

Ill try and explain.

I have a form which has 3 forms built within it, each with unique questions etc, I then have a Excel workbook with three sheets, each sheet has a unique table.

I have used Power Automate to populate the tablets depending on the response from the forms. It's working well except that every time a new form is submitted each table has a new row added, even though the flow states the specific tablet to add a row too.3

I have tried to arrange the flow in two ways, One is to have a single flow with 3 add rows after each other and the other ways of having three separate flows, one for each table, but they both produce the same result.

Is it possible to add rows to a specific table within a workbook with out adding rows to the other tables

Sorry if this does not make sense, it hard to explain

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Vish WR 3,748 on at

Like
a
(0)

Report
Copy link

Link copied!
@GA-06052302-0

It sounds like the flow is triggering all the “Add a row into a table” actions every time the form is submitted, so each table gets a blank/new row even when it’s not meant to.

You can try add a Condition before each “Add row” action so Power Automate only writes to the specific table related to that form response. For example, check which form section was completed, then only run the matching table action.

Also make sure:

Each Excel table has a unique name

The correct table is selected in each action

Empty actions are not still running in parallel

Vishnu WR

LinkedIn - My Tech Space

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥

Was this reply helpful? Yes No
GA-06052302-0 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank for your response,

I had gathered that may be the case, Im trying to be smart and have the three tables within on workbook, instead of the easy way of having 3 different workbooks.

I have checked everything and each table has a unique name, so can't figure out why it's doing it. Each flow has the correct file and table. Im not sure about empty actions.

Yes, you may be correct about adding a condition within the flow, but unfortunately, my skills do not go that far as to programming conditions.

If there is not a simpler answer, then ill just try the simple idea and have 3 different workbooks. :(

But thank you for your help

Was this reply helpful? Yes No