web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate How to update rows in ...

Power Automate

Answered

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

(0) Share

Report

Report

Posted on by afaro053

9

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:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-yetonggu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
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

Join the conversation