Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

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

Posted on by 60

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

pastedimage1621353423718v1.png

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

pastedimage1621353692255v2.png

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.

  • Suggested answer
    Bipin D365 Profile Picture
    Bipin D365 28,964 Super User 2024 Season 1 on at
    RE: How to copy "ownerid" column in another Dynamics environment table in Azure data factory?

    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.

  • AndrewMacInnes Profile Picture
    AndrewMacInnes 20 on at
    RE: How to copy "ownerid" column in another Dynamics environment table in Azure data factory?

    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

  • Suggested answer
    Nya Profile Picture
    Nya 29,056 on at
    RE: How to copy "ownerid" column in another Dynamics environment table in Azure data factory?

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans