Power Platform Community Forum Thread Details

Hi,

I have connected an Excel Online File to my PowerApp to save the data on a OneDrive Location. My objective is to save the start and end times of a given trip, prefferably in the format "DD.MM.YYYY hh:mm". However the only way I have found that the Canvas app can interpret the DateTime back into the App upon reloading is "DD-MM-YYYYDHH:MM:SST".

If I attempt to save the date time as Text or Date Format, it saves it as an integer which seems to be the Epoch representation of the date. As you can see from the image, the Text output (located below CrossBorderTime_out) is a correct format, but when it saves its incorrect.

Excel has been changed to all potential Date and DateTime formats. Currently on DD-MM-YYYY hh:mm which is given an error

I would take either of the top two DateTime versions, just as long as its consistent.

Thanks in Advance.