Unanswered

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

(0) Share

Report

Posted on 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:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

LaurensM 12,516 Moderator on at

Like (0)

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

Was this reply helpful? Yes No
Davidk2022 8 on at

Like (0)

Report

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.

Was this reply helpful? Yes No