Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Answered

Required Fields for Contact

(0) ShareShare
ReportReport
Posted on by 35

This is a really basic question. I'm settingg up a DataFlow in Power Apps to my Dynamics 365 Marketing Contact table.  I'm loading 

  • Flirstname
  • Lastname
  • Email
  • customfield Yes/No
  • customfield2 yes/No
  • externalkey int

I'm getting an error

rror code: 0x80040239, Message: DateTime is less than minumum value supported by CrmDateTime. Actual value: 01/01/0001 00:00:00, Minimum value supported:

I don't see any required data fields in the Power Apps portal. What am I missing?

  • cloflyMao Profile Picture
    cloflyMao 25,202 on at
    RE: Required Fields for Contact

    Hi jarthda,

    It is very glad that your problem has been solved.

    Thanks for sharing the solution.

    Regards,

    Clofly

  • Verified answer
    jarthda Profile Picture
    jarthda 35 on at
    RE: Required Fields for Contact

    thanks for the response. Let me provide an update.  I am wanting to Upsert and have only been able to use Dataflows to load new records. I've since moved my project over to ADF Azure Data Factory. There I have some success upsert just a single custom field from an alternate key. Further, regarding D365 I found data templates in the Manage Data section of advanced settings. I hope this help anyone else.

  • cloflyMao Profile Picture
    cloflyMao 25,202 on at
    RE: Required Fields for Contact

    Hi jarthda,

    Could you share necessary steps which might help to reproduce your issue?

    I am connecting to Dynamics 365 via OData method, and I only chose 6 fields as you mentioned to load table of contacts without trouble.

    77448.JPG

    Regards,

    Clofly

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,979 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,848 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans