web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / Problem importing data...
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested Answer

Problem importing data from azure sql db using azure data factory into Dynamics 365 createdon and modifiedon fields

(0) ShareShare
ReportReport
Posted on by AndrewMacInnes 20

I want to copy account records from an azure sql db to D365. I am using Azure data factory to achieve this.

I am having problems with a couple of D365 fields, createdon and modifiedon. When I try to populate these with the values from my db they are ignored and D365 instead uses the datetime when I actually insert them into D365.

I've done some reading up and it seems these are locked fields. There are a number of ways to get round this from other tools but I haven't seen a way to get around this issue when importing records from azure data factory.

I've tried making the source field in the db that I want to use, nVarChar, Date and DateTime but all are ignored.

Does anyone know if this is possible and if so how I can achieve it? Can I do it through ADF alone or do I need to configure D365 to allow these fields to be created with a custom value?

Thanks

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hi AndrewMacInnes,

    Maybe you can refer following links:

    How to – Use OverriddenCreatedOn or Record Created On field to update Created On field in Dynamics 365 – Nishant Rana's Weblog 

    dynamics crm - Is there way to update modified on, created on and created by fields in CRM? - Stack Overflow

  • Suggested answer
    Bipin D365 Profile Picture
    Bipin D365 28,983 Moderator on at

    Hi,

    For Createdon You can map it to Overridecreatedon field.

    I don't think modified on field value can be retained. You can try creating new custom field to store the legacy value.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Siv Sagar Profile Picture

Siv Sagar 93 Super User 2025 Season 2

#2
#ManoVerse Profile Picture

#ManoVerse 76

#3
Martin Dráb Profile Picture

Martin Dráb 64 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Identifying an Org as CDS or Dynamics
Get batch job history log from D365 FO to Power Automate
Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans