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

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

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."

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @Anonymous ,

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,

Was this reply helpful? Yes No