how to show only Time in Powerapps from Date and Time format in sharepoint

[pollyzzz]

Is it possible to show only Time in Powerapps from SharePoint database that the data is stored in date and time format?

Thank you very much

[eka24]

If is in a Textbox:(

Text(Textbox1,"hh:mm:ss")

In a Gallery label:

Text(ThisItem.Column,"hh:mm:ss")

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[mdevaney]

@pollyzzz 

Yes, you can format date & time values using the TEXT function

Text(ThisItem.DateColumn, ShortTime24)

or

Text(ThisItem.DateColumn, ShortTime)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[v-xida-msft · Accepted solution]

Hi @pollyzzz ,

Do you want to only show Time value from the Date Time type field in your SP list?

Based on the needs that you mentioned, I think the Text function could achieve your needs. I have made a test on my side, please try the following formula:

Set the Text property of a Label to following:

Text(Now(), "HH:mm AM/PM")

If you list your SP List records in a Gallery, and you want to display the Time value from the Date time field in this Gallery, add a Label in this Gallery, set the Text property to following:

Text(ThisItem.DateTimeField, "HH:mm AM/PM")

More details about Text function, please check the following article:

Text function

Best regards,