I built a power app that is connected to an excel sheet. The odd thing is that a date time field value in excel is showing up in the date/time field in the powerapp with a difference of 16 hours. Does anyone know why this is? It’s very odd. Mike
@Mbruse Usually any dates and times brought in from Excel are displayed in local time because they do not include any timezone information. But in your case offset is occurring. Perhaps the datetime is being converted to UTC for some strange reason.
Try this code to convert from UTC to local time. Replace MyDatetime with your own Excel column name.