How to update rows in an excel instead of appending if the rows already exists for that week?

(0) Share

Report

Posted on by afaro053

I have an excel file in which rows are being copied and appended in it once every week with a timestamp column.

I want the values in those rows to be updated (or deleted and added again) if the flow is manually run for a second time that week instead of adding duplicate rows for that week.

How do I go about doing this?

Thank you in advance.

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-yetonggu-msft on at

Like (1)

Report
Hi @afaro053 ,

I did a test for your reference.

In my scenario:

The ID columns in my two tables are one-to-one correspondence and will not change, only then can the copy table and update the table uniquely correspond to the update and create new rows.

My Copied Table:

My Updated Table:

I did a test for your reference.

In my scenario:

ID eq '@{items('Apply_to_each')?['ID']}'

length(outputs('List_rows_present_in_a_table_2')?['body/value'])

The Result:

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No