Skip to main content

Notifications

Community site session details

Community site session details

Session Id : nGJEZOdoT+zaeDIoaWDK/P
Power Apps - Building Power Apps
Unanswered

Blank dates showing up in Gallery as 12/31/1899

Like (0) ShareShare
ReportReport
Posted on 19 Dec 2022 16:47:29 by 8

I am working on a power app that is pulling data from a data entity within D365 F&O.  Some of the dates are blank within the entity but when the data is pulled into a gallery within the power app the dates show up as 12/31/1899. Is there anyway to get these to actually show up as blank. The change will have to be done on the Power app side as the entity side from D365 is pretty rigid.  Sample shown below.  Thank you everyone.

 

Davidk2022_0-1671468351021.png

 

Categories:
  • Davidk2022 Profile Picture
    8 on 20 Dec 2022 at 16:04:51
    Re: Blank dates showing up in Gallery as 12/31/1899

    Hello, I don't think a date picker will work these are values coming from a data entity into a collection, not sure how the date picker comes into play.  

     

    As for the second the date shows in the collection as 12/31/1899. I think that probably means the data is coming from the entity as a 0 not a null or blank value, when you open the entity in excel it shows blank as that is how excel is reporting the 0 is my guess.

  • LaurensM Profile Picture
    12,510 Super User 2025 Season 1 on 19 Dec 2022 at 16:56:04
    Re: Blank dates showing up in Gallery as 12/31/1899

    @Davidk2022 what control are you using the show the dates?

    Should you use a Date Picker (in view mode), you could change the code within InputTextPlaceholder property to:

     

    If(IsBlank(Self.SelectedDate), Blank())

     

     

    If you are using another control, could you check if you receive the dates as null values or as 12/31/1899.
    (You can test this by fetching them in a collection)

     

    I hope this helps!

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 the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard >

Loading started