web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Timevalues do not alig...

Power Apps

Unanswered

Timevalues do not align with data source

(0) Share

Report

Report

Posted on by avocaduhs

Hello all,

I am using the following formula to return time values in my power app:

Text(TimeValue(ThisItem.ETD), "[$-en-US]HH:mm")

The data source is Excel and the column ETD contains the time values referred to in the above statement. Somehow, the formula adds one hour on top of the timevalues in Excel. This does not happen when I simply use: TimeValue(ThisItem.ETD)

TimeValue(ThisItem.ETD)

The time is then displayed correctly in the power app, but in the format example: 11:50 AM.

Does anyone know why the shown time is changing when I try to change the format? Thank you in advance!

Categories:

Building Power Apps

All responses Img

All responses (0)

Answers Img

Answers (0)

Join the conversation