Dataflow - Update operation for existing key in Dataverse

Hello v-kkf-msft ,

Apologize for the late response.

Thank you for sharing the above documentations.

While I went through all of them, I did not find anything that resembled what I am trying to accomplish.

It is simply a matter of replacing the old key of the column with the newly added key column that I have created.

In addition, I have another table related to the contact called contacts transactions, in which I need to replace the old key with the new one that has been updated in the first table.

The result of my configuration always creates duplicate data as per the below screenshot:

Setup:

I still need to find a way to update the existing key with the new key in both tables to avoid creating duplicates or losing the data

.

Could you please replicate and provide an example of the scenario I am trying to achieve?

Your help is highly appreciated.

Thank you!