Unanswered

Copy data from one table and replace it in another

(0) Share

Report

Posted on by Poxdron

Hi! I'm trying to build a flow where I copy data in a table and replacing it in another table using "List rows present in a table", their respective "for each" and an "update a row". But something in the logic in my flow is making a conflict. Do you know what it can be?

Categories:

Building flows

image.png

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-mengmli-msft on at

Like (0)

Report

Hi @Poxdron ,

You should use something of current record in "Apply to each" to get specific record of another table.

For example, two table have same ID column to match records.

Here is a guidance for your reference.

Best regards,

Rimmon

Was this reply helpful? Yes No
Poxdron 2 on at

Like (0)

Report

Thank You! I kinda see what you mean, but there is something I don't understand well: You used the value of the table 1 as a key value in the update a row?

Was this reply helpful? Yes No
v-mengmli-msft on at

Like (0)

Report

Hi @Poxdron ,

Yes, you should use something in two tables to find matched rows. The key value is used to getting the matched row in table2 and update the row.

Best regards,

Rimmon

Was this reply helpful? Yes No