Microsoft Dynamics 365 | Integration, Dataverse...

Update operation for existing key in Dataverse

(0) Share

Report

Posted on by EBMRay

899

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!

All responses (5)

Answers (0)

EBMRay 899 on at

Like (0)

Report

RE: Update operation for existing key in Dataverse

Hello KK-365 ,

Yes, so the workaround is to use either Logic Apps or Power Automate to achieve the results we want.

We used dataflow because we have a large data set that we imported using this tool but it seems it has the update operation limitation.

What about the Bulk Data updater tool in xrmtoolbox have u ever tried to perform an update operation using it?

Thamk you!
Suggested answer

KK-365 1,010 on at

Like (0)

Report

RE: Update operation for existing key in Dataverse

If you are running a power automate for 250K records, Trigger based is not a good Idea.

It will stuck into threshhold as you mentioned. (for me it goes max to max upto 500-700 records)

You can also use logic apps. However in both scenarios of power automate or logic app, make them as scheduled job every 10 min and limit the count to max 250 in 1 attempt.

It may be time consuming but it will do your job.
EBMRay 899 on at

Like (0)

Report

RE: Update operation for existing key in Dataverse

Hello KK-365 ,

Thank you for your reply.

No, I don't want to update the primary contact ID. I have another unique key column of type text which needs to be updated and below is a screenshot of the key that is added under contacts:

As for the dataflow, below is a screenshot for the data mapping:

The one highlighted in red is the old key and the one in green is the new key.

However, it seems that dataflow might not support this update operation to replace the old key with the new key.

Maybe Power Automate might be a better solution. If so, I have around 250K contacts and it might run into a threshold issue because I already experienced that before.

Please let me know your workaround to achieve the above.

Thank you!
Suggested answer

KK-365 1,010 on at

Like (1)

Report

RE: Update operation for existing key in Dataverse

It depends, If you are trying to update the Contactid, you can not update it with some randon number as this is a GUID field.

If contact key in your dataverse is a text field which needs to be updated with the new Contact Key, it is doable.

Please share some screenshot of your flow to investigate further.
Community Member on at

Like (0)

Report

RE: Update operation for existing key in Dataverse

Hi,

Maybe you need post thread in the Power apps forum:

powerusers.microsoft.com/.../PA_Comm_Forums