Answered

Duplicates when transferring tables and google sheats to excel table online

(0) Share

Report

Posted on by unibel

Hi i have this problem and i don't know how to solve it yet. I have created a trigger to transfer data from google sheats table to excel online table.

1) Running the schedule trigger
2) Get data from excel online table ( list rows present ina a table)
3) I delete all rows
4) I get rows get rows from google sheats
5) Add rows to excel table online

And the following happens - delete all rows, get all rows from google sheats and add rows repeatedly with repetition to excel table online. Each row can be duplicated from 2 to 10 times. Total from google table of 40 rows I get a table of 350-400 rows in excel online. But I noticed this thing - if I manually delete all lines in excel online file except the first one, then I get normal data from google sheats in excel online and there is no duplication, except for 1 line which I did not delete. If I manually delete all rows from the table, then unfortunately the problem continues and the data is not added to excel online. Can you tell me who has encountered this problem and how to avoid duplicate rows when transferring data from google sheats to excel online?

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

rzaneti 4,379 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @unibel ,

Could you please share an image of your current flow design, and the inputs for the "Delete a row" action?

Was this reply helpful? Yes No
unibel 11 on at

Like (0)

Report
Copy link

Link copied!

The script works ok, it cleans the table faster than the delete rows trigger

Was this reply helpful? Yes No
Verified answer

rzaneti 4,379 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @unibel ,

Thank you for sharing the images! I can see that you have 2 nested loops, one to iterate the Google Sheets records, and another to iterate the "List rows present in a table" Excel action.

I'm not sure about why are you looping all Excel records, but this is why you are getting the duplicates. The "Add a row into a table" action is allocated inside the Excel loop, which is inside the G. Sheets loop, so for each Google Sheets record, your flow runs the adding action "n" times (being "n" the qty of records in the Excel table).

Also, note that your "Run script" is allocated after the "List rows present in a table" action, so you are looping all the records existing before the "delete" step.

Do you have any reason for listing the Excel records and looping them in the flow? Based on the shared images, it looks like you are not actually using this data, so you could solve the duplicates by just removing the inner "Apply to each".

Let me know if it works for you or if you need any additional help!

-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

http://digitalmill.net/
https://www.linkedin.com/in/raphael-haus-zaneti/

Was this reply helpful? Yes No
unibel 11 on at

Like (0)

Report
Copy link

Link copied!

Really had a redundant repeat action for google sheats, I removed that and everything works like clockwork! Thank you very much!

Was this reply helpful? Yes No