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.
Issue with DateTime columns when pulling from Excel spreadsheet using Power Apps
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.
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 ;)
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.