Microsoft Dynamics 365 | Integration, Dataverse...

How to copy "ownerid" column in another Dynamics environment table in Azure data factory?

(0) Share

Report

Posted on by TerryShowman

Hi, Is there a clear way when copying data(ownership) from a Dynamics environment to another, through "Azure data factory". here an illustration

ownerid guid ---> ownerid

mapping owner id that way trows me an error

Failure happened on 'Sink' side. ErrorCode=DynamicsMissingTargetForMultiTargetLookupField,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=,Source=,''Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Cannot find the target column for multi-target lookup field: 'ownerid'.

but doing this way

ownerid guid --> ownerid@EntityReference

the copy data activity works well but the records ownership is set to the "user application configured"

I mean like if source entity A the owner is John in the target entity B the owner is UserApplication but beacuse when you add a linked service on azure you have to place some credentials or an application for authentication and that user is the one how the ownership is like overwriting in the records.

Any advice or a blog for how to... I looked some blogs but they said that using ownerid guid --> ownerid@EntityReference will work but changes the ownership :/. Thanks.

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Nya 29,060 on at

Like (0)

Report

Hi,

Here is a similar issue which you can refer to.

Getting Issues while copying data to Ownerid field in Crm using Copy Activity (microsoft.com)

If this helped you, I'd appreciate it if you'd mark this as a Verified Answer, which may in turn help others as well.

Best Regards,

Nya

Was this reply helpful? Yes No
AndrewMacInnes 20 on at

Like (0)

Report

I've been getting the same issue where the copy activity seems to work using the method you describe above (i.e my pipeline is successfully executed) but when I look at the owner column in the D365 front end it has in fact used the user account ADF is running under, not the user id I tried to assign.

Did you manage to make any headway with this?

Regards

Andrew

Was this reply helpful? Yes No
Suggested answer

Bipin D365 28,983 Moderator on at

Like (0)

Report

Hi,

Can you create Alternate key in your User table based on Email address and map owner lookup using alternate key instead of using guid.

Because guid be different in two instances.

Was this reply helpful? Yes No