Answered

Issue with DateTime columns when pulling from Excel spreadsheet using Power Apps

(0) Share

Report

Posted on by HarZ

Hello Power Community,

I am seeking assistance understanding how to resolve DateTimes when pulling them into another Power App. Currently I have a Spreadsheet holding some check in/out times displayed in 24h time.

However when I pull it out into a Data Table in a Power App it displays as completely different time period. I've ensured that the formatted cells are Time and when I change it to text it just becomes decimals numbers.

The code for the text is Text(ThisItem.'Check In Time',DateTimeFormat.LongDateTime) (Displayed long here for troubleshooting but ShortTime otherwise)

Additionally I need the case where there is no check out time (A client hasn't checked out yet). However it shows up as error.
The current code for text in this box is this: If(IsBlank(ThisItem.'Check Out Time') , " ",Text(ThisItem.'Check Out Time'))

Are Excel's values not considered blank? If not, what is it?

Any assistance is appreciated. Thank you in advance.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Chriddle 8,691 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

December 30, 1899 is day 0 in Excel. Since your Excel cell does not provide a date, you will receive this one.

Maybe you get the wrong time because Excel doesn't handle time zones and Power Automate assumes UTC.

This UTC time seems to be calculated to your current timezone (are you UTC-8, e.g. California?).

If so, you'll need to calculate the correct UTC time from this mess before inserting it into Dataverse.

You should not insert a space if a datetime is expected.

Conclusion: Don't use Excel, especially if you have to work with dates and times ;)

Was this reply helpful? Yes No
HarZ 17 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the informative response! Didn't know it was such a weird case of Excel. What do you recommend in place of it? Additionally, would it be possible to change the export type into this Excel spreadsheet to be a String instead of DateTime? I don't need datetimes as I'm not manipulating any data after its been entered. As I've mentioned converting the Excel table itself just creates decimal numbers.

Was this reply helpful? Yes No
Chriddle 8,691 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Set the cell format in Excel to "text", then insert your time strings.

After that, you get the cell values as strings.

Was this reply helpful? Yes No