Unanswered

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

Like (0) Share

Report

Posted on 19 Dec 2022 16:47:29 by Davidk2022

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.

Categories:

Connecting to Data

All responses (2)

Answers (0)

Davidk2022 8 on 20 Dec 2022 at 16:04:51

Like (0)

Report

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 12,510 Super User 2025 Season 1 on 19 Dec 2022 at 16:56:04

Like (0)

Report
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!