cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pollyzzz
Helper II
Helper II

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
v-xida-msft
Community Support
Community Support

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:

1.JPG

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
eka24
Super User
Super User

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
Super User
Super User

@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
Community Support
Community Support

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:

1.JPG

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,092)