web

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

News and Announcements icon

Power Platform CommunityForums Power Apps time only no date

Power Apps

Answered

time only no date

(0) Share

Report

Report

Posted on by mrleetyler

270

hi all,

i have an OnSelect pulling the current UTC time on press into a collection example output: (2021-04-16T02:26:59.112Z)

the format as it is needs to stay in the collection for data collection purposes.

however, i want to just display the TIME in a textbox.

if i put the default to

text(readyTime,"hh:mm:ss")

it doesn't register.

i'm assuming this is because it's not picking up that UTC string as a datetime?

how can i get around this but keeping the datetime string and just extracting the time from it

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

RusselThomas 4,014 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @mrleetyler ,
If it's originally a text type, you should be able to convert it to datetime and then extract the time as text again - The idea would be convert the text to datetime, (which automatically applies a timezone offset), then adjust for timezone offset, then reference the hours, minutes and seconds.
Try this;

Text(DateAdd(DateTimeValue(readyTime, "en-US"), TimeZoneOffset(), Minutes), "[$-en-US]hh:mm:ss")

Hope this helps,
RT

Was this reply helpful? Yes No
mrleetyler 270 on at

Like
a
(1)

Report
Copy link

Link copied!

perfect thanks so much!

Was this reply helpful? Yes No

Join the conversation