Date picker spontaneously passing Unix time

Like (0) Share

Report

Posted on 14 Nov 2024 17:03:40 by J-G

130

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:

General Questions

Connecting to Data

All responses (2)

Answers (1)

Verified answer

J-G 130 on 14 Nov 2024 at 19:46:44

Like (2)

Report

Date picker spontaneously passing Unix time

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.
Suggested answer

cha_cha 4,932 Super User 2025 Season 1 on 14 Nov 2024 at 19:40:04

Like (1)

Report
Date picker spontaneously passing Unix time

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