Dataflow - Update operation for existing key in Dataverse

[Synth]

Hello,

I built a dataflow that is connected to an excel sheet that feeds data in dataverse.

I already created a key for the table and map it to the key column in my sheet and triggered the flow as it works successfully.

The problem that I am struggling with is the below:

In our excel sheet, we have updated the contact key as we need a new column called "NEWKEY" and we need to update it the same in dataverse. however, it seems that dataflow does not support the update operation. If possible, during the updates, I want to make sure we don't lose the associated records with the contacts that we're changing for them the keys since we have custom relationship tables associated with that key but as a first step, we need to update the parent table.

The main goal to achieve this is to replace the old key with the new key that I highlighted in the above screenshot with the data that already exists in dataverse.

What will be the workaround to update the contacts with the new key provided in the excel sheet?

Could you please provide an example or steps needed?

Any help is greatly appreciated.
Thank you!

[Krishna09]

Hello @Synth ,

Have solved updating parting. Even I am looking for same process. I have created alternate keys . I  donot understand how to update data in dataverse with this alternate key columns I have to update the columns in dataverse.

[v-kkf-msft]

Hi @Synth ,

Please see if these documents are helpful.

Add data to a table in Microsoft Dataverse by using Power Query 

https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Dataflows-Refresh-behavior/td-p/1244649 

Create and use dataflows in Power Apps 

Best Regards,
Winniz

[Synth]

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!