Unanswered

Take a date and time type column from a sharepoint list and filter only time, ignoring date and displaying it in a text label in powerapps

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hey! Guys. I have this Date and Time type Column in Sharepoint list named Appointment Day and Time. I only want to get the value of Time ignoring the date and to display it in the text label or text box in the powerapps. My Sharepoint list name is Appointments. Any help would be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (0)

Sort by

Jose Ramon 107 on at

Like (0)

Report
Copy link

Link copied!
Try with this
Text(ThisItem.Created,"hh:mm:ss")

Was this reply helpful? Yes No
SpongYe 5,721 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous

Try this:

Text(ThisItem.'Appointment Day and Time', "hh:mm AM/PM"); Text(ThisItem.'Appointment Day and Time', DateTimeFormat.ShortTime) //in 24H replace with ShortTime24
If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Getting this error.

Was this reply helpful? Yes No
Jose Ramon 107 on at

Like (0)

Report
Copy link

Link copied!

ThisItem refers to the selected item in a gallery, in your case: how are you displaying the information of the other columns on the screen? see how it is placed in the other columns and replace ThisItem by the value you have in the other columns

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I am not using a gallery it's just a text box or text label in powerapps.

Was this reply helpful? Yes No
Jose Ramon 107 on at

Like (0)

Report
Copy link

Link copied!

But you are getting the information from SharePoint right? How do you fill that textbox or textlabel with the SharePoint information? Well, as you show the rest of the fields, in the one you want to show only the date, change ThisItem to the one you have in the rest of the fields.

If you are using a Form, you need to unblock datacard to change Default property with the value that we have indicated

Was this reply helpful? Yes No
SpongYe 5,721 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous

You first have to select the record for which time you want to show in the label using a LookUp.
Text( LookUp(Employees, ID = YourID, 'Appointment Day and Time'), DateTimeFormat.ShortTime )
The LookUp returns 1 row and then you can select the Appointment Day and Time to view in ShortTime.

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

What is the ID = Your ID in here?

Was this reply helpful? Yes No
SpongYe 5,721 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
I just misread your last comment > just a text box or text label in powerapps.

We need the text box or text label with the time you want to use:
Text( Label1.Text, DateTimeFormat.ShortTime )
If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

But i need to get the date from sharepoint list column, Appointment Day and time and i need only time to display.

Was this reply helpful? Yes No