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.