Answered

Date picker spontaneously passing Unix time

(0) Share

Report

Posted on by J-G

134

After returning to a project that's been on hold for a month, I noticed that any new writes to the excel file it draws from using a form submission tries to read the selected date time as an UNIX time value. This can't be read and displays on both the data table visualizer and the excel file as just a very long number. I've double checked the formatting on that column in excel and confirmed the datepicker is formatted as a short date, so I'm not quite sure where this is coming from. It's doubly strange because there's two other date pickers on the form that work perfectly fine with the exact same configuration, and this issue was absent just a month ago.

Error Message:

"The value '1732683600000' cannot be converted to a date or time value"

Or a similarly long number.

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Suggested answer

cha_cha 4,932 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hello J-G,

Since you confirmed that Excel is formatter and the Power Apps control are all good, you might want to try:

Reconnect Excel - do this in Power Apps

Duplicate the excel file, replace the current Excel data source in Power Apps

Recreate the app.

This is a known issue with excel specially when it comes to inconsistency with Data Format.

Here is a detail about it if you want to know more: https://www.youtube.com/watch?v=RtmZM3tm2Zs&ab_channel=ShaneYoung
Verified answer

J-G 134 on at

Like
a
(2)

Report
Copy link

Link copied!

It turns out that somehow some of the inputs swapped formatting and that just broke the entire column. I deleted all of the rows (only test data) and it's working as intended.