cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rubensmoc
Level: Powered On

Get Data Excel file - CDS Load failed - code: 0x80040239 DateTime is less than minumum value supported by CrmDateTime

Get Data Excel file - A simple file with three columns: Person Id (Id Beneficiario - Whole), Name (Nome -Text) and Date of Birth (Data Nascimento - Date) resulted on a CDS Load failed - code: 0x80040239 DateTime is less than minumum value supported by CrmDateTime. ":"DateTime is less than minumum value supported by CrmDateTime. Actual value: 01/01/0001 00:00:00, Minimum value supported: 01/01/1753 00:00:00"

There is no invalid date on the DOB Field - Excel file attached.

 

Any help?

 

Tks,

Rubens Pereira

 

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft v-siky-msft
Microsoft

Re: Get Data Excel file - CDS Load failed - code: 0x80040239 DateTime is less than minumum value supported by CrmDateTime

Hi @rubensmoc ,

 

Could you share more details with your scenario? How do you import the Excel files? The detailed steps would help us reproduce and solve the problem

I have made a test on my side, and don't have any issue, the DOB.xlsx can be imported successfully.

Snipaste_2019-11-21_14-40-08.png

The following is my steps, hope this helps.

1. PowerApps - Data - Entity -Get Data - Excel

2. Select the excel file from OneDrive - choose data

3. query the data- modify the column name 

4. choose load to new entity, check the "Delete rows ..", set ID to primary name field and set its type to Text

5. wait the import process

Snipaste_2019-11-21_14-54-29.pngSnipaste_2019-11-21_14-56-15.png

Snipaste_2019-11-21_14-59-01.png  Snipaste_2019-11-21_15-29-46.png

Best regards,

Sik

View solution in original post

1 REPLY 1
Microsoft v-siky-msft
Microsoft

Re: Get Data Excel file - CDS Load failed - code: 0x80040239 DateTime is less than minumum value supported by CrmDateTime

Hi @rubensmoc ,

 

Could you share more details with your scenario? How do you import the Excel files? The detailed steps would help us reproduce and solve the problem

I have made a test on my side, and don't have any issue, the DOB.xlsx can be imported successfully.

Snipaste_2019-11-21_14-40-08.png

The following is my steps, hope this helps.

1. PowerApps - Data - Entity -Get Data - Excel

2. Select the excel file from OneDrive - choose data

3. query the data- modify the column name 

4. choose load to new entity, check the "Delete rows ..", set ID to primary name field and set its type to Text

5. wait the import process

Snipaste_2019-11-21_14-54-29.pngSnipaste_2019-11-21_14-56-15.png

Snipaste_2019-11-21_14-59-01.png  Snipaste_2019-11-21_15-29-46.png

Best regards,

Sik

View solution in original post

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors
Users online (5,578)