Date Not Formatting - Excel Online Data Source in Canvas

(0) Share

Report

Posted on by jburns323

Hey all,

I am having an issue that I've been racking my brain over the past couple days...

I have user form, which takes information, and updates a table added to the same screen. Part of this includes a start and end date of a reservation. I'm having issues where the table shows serialized time, instead of formatted time.

I have changed the formatting on the Excel to show the needed formatting, and in the formula of a "submit" button, I have added formatting to that as well. Nothing seems to have been working for me...

Data Table Control feature enabled in settings
Text(ThisItem.{Table Control},"mm/dd") has been attempted
Disconnect and reconnect has also been attempted

Excel Format:

Patch formula in "Submit" button:

Table after submission:

Thank you all very much for your help here,

Jake

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

jinivthakkar 4,187 on at

Like
a
(0)

Report
Copy link

Link copied!

@jburns323 please check this out, it says - If you connected to the OneDrive, I suggest that you change the column type to a General type.

https://powerusers.microsoft.com/t5/Building-Power-Apps/wrong-date-format-from-excel/m-p/1296159

--------------------------------------------------------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
jburns323 13 on at

Like
a
(0)

Report
Copy link

Link copied!

Good afternoon @jinivthakkar ,

Manually set the cells to General, but after the submit command was sent (in my original request) it unfortunately changes the formatting of the cell from General to Custom with a date format:

Was this reply helpful? Yes No
Verified answer

jburns323 13 on at

Like
a
(1)

Report
Copy link

Link copied!

I seem to have figured it out - by something I overlooked entirely. I added "date" to the "Reservation Start" and "Reservation End" headers, which allowed something in the back end to realize that these were date-formatted values.

Thank you very much for your assistance here and for your quick response!

Was this reply helpful? Yes No