cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Blank Date field gets converted to 1/1/1753

Hi I am new to PowerApps. I am trying to upload data to an entity in a Model Driven App via the "Get Data From Excel" functionality.

The problem I am having is when I try to upload data to a date field with a blank value, the blank data automatically gets converted to "1/1/1753". How do I upload a blank or null value via the "Get Data From Excel"?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Blank Date field gets converted to 1/1/1753

Hi FDLConstellis ,

 

Just use Empty(item()?['DateField']) not equal to false in the condition.

 

 Note

All date and time attributes in Common Data Service support values as early as 1/1/1753 12:00 AM.

 

I hope it helps you.

Javier

View solution in original post

1 REPLY 1
Highlighted
Microsoft
Microsoft

Re: Blank Date field gets converted to 1/1/1753

Hi FDLConstellis ,

 

Just use Empty(item()?['DateField']) not equal to false in the condition.

 

 Note

All date and time attributes in Common Data Service support values as early as 1/1/1753 12:00 AM.

 

I hope it helps you.

Javier

View solution in original post

Helpful resources

Announcements
Check this Out

Announcing

Class of 2020- Season 2

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,131)