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
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,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
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
Hi @MichaelCornwell ,
Edit:
You need to add the condition below the list rows action.
Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
I took out the last step and replaced with your suggestion, it still has difficulties.
User | Count |
---|---|
89 | |
40 | |
23 | |
20 | |
16 |
User | Count |
---|---|
130 | |
50 | |
48 | |
35 | |
26 |