MS Flow cannot copy table to a new worksheet table

[StewS73]

Hi,

I am trying to copy a table from one worksheet to a separate 365 worksheet using Flow but I am really struggling. I can easily extract the rows (cannot delete the rows in the primary worksheet as I also need them there), and then place them into the new worksheet table but each time the flow runs it then duplicates the rows in the new worksheets table.

So, I either need to be able to have a flow that simply copies the table from worksheet to worksheet overwriting whatever is there currently or, an automated formula to remove the oldest duplicate (if present) from the second worksheet.

My current flow is setup as follows:

1 - Run every 1 hour
2 - List rows present in a table (see picture attached[List Row])
3 - Apply row to a table (see picture attached [Apply to Each])

This results in the row being duplicated on each run. See attached [Primary Table] - Source of the data & [Secondary Table] - the destination of data where duplication happens each Flow run.

Slightly confused... so any help much appreciated or i anyone knows of a similar place for MS Flow questions.

TIA

[AliGW]

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do with Flow.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[StewS73]

Updated title.

[AliGW]

I think you might need to give some detail about how you are setting up the flow.

[StewS73]

Additional details added.

[StewS73]

Hi,

Can this post now be unlocked please?

[AliGW]

It has never been locked.

103 views and no responses - I did think it was a bit niche, and as I thought, not many people here (if any) seem to have enough experience of MS Flow to help you out. Sorry about that.