Excel table KEEPS updating but It should only update once

[MichaelCornwell]

Hi

I am trying to get data from a Form, this feeds into a spreadsheet (S1), from there I want a key piece of info to feed into another spreadsheet (S2). I have built the flow and S1 updates with no issues at all. However, S2 adds about 20 rows of the same information when I only want one row. I eventually want 6 spreadsheets feeding into S2 but cannot manage 1 at the moment!

I will paste the flow below:

Any help greatly appreciated.

Thanks

[v-jefferni]

Hi @MichaelCornwell ,

According to your flow, I believe there are more than 20 rows in the "Sound Completion" spreadsheet table1. S2 will either update a row or add new rows based on the condition checker. So my question is, why are you using the list rows action again? This should be a logic problem, I think you are wanting to update or create items in S2 based on the new created item in S1. If so, you need to add condition in Filter query of the list rows action, check the condition on the amount of rows from the output:

if count >= 1, for each row update the value, if not add a new row. So the add a row will be out of the loop.

Best regards,

[MichaelCornwell]

Thanks for the reply @v-jefferni Would I put the Condition in before, after or instead of list row? (I'm a novice and learnt the original flow from YouTube). TIA

[v-jefferni]

Hi @MichaelCornwell ,

Edit:

You need to add the condition below the list rows action.

Best regards,

[MichaelCornwell]

I took out the last step and replaced with your suggestion, it still has difficulties.