Adding a row to a table from another table

[Matt_C]

I have a flow that is designed to add data from one table to another. The only problem is that instead of just one row it will add multiple row of the same data. I have tried a few things but am not sure where to go now. I have attached screenshots for you wonderful people to help me out. The one below is because the one that added on a schedule would add thousands of rows.

Thanks

[annajhaveri]

You are adding row in side Apply to Each 2 loop action, it could be due to the loop, multiple rows are getting added.

[Matt_C]

Hi @annajhaveri it won't let me do it without a second loop the first loop updates a row which works fine the second adds a row. It is adding from a different file which is why it is inside the loop it won't let me create it any other way.

[annajhaveri]

Hello @Matt_C , how many times does the second loop runs, is number of times the second loop runs and those number of rows are added to your excel? If yes, then you can put some condition inside the loop to prevent it from adding multiple rows. If you could share screenshots of your flow run, then it would give more idea on the issue.

[Matt_C]

Thanks for the thought, I will have a look at it but the numbers match what is in the spreadsheet as it should be. 

[annajhaveri · Accepted solution]

So based on your flow run, the second loop is running for 103 times, are 103 rows getting added to your excel? I also see that you have a condition inside the loop, so number of rows being added would also depend on that condition. You may want to add one additional condition  which checks if row is already added by the flow to the excel. You can set a variable after Add row to table action, and then check that variable in condition.

[Matt_C]

Thanks @annajhaveri Such an easy fix, no wonder I missed it

[annajhaveri]

Thanks @Matt_C , I am glad my inputs helped you.