Announcements
Hi all,
I have a table in share point with a data column with hour (example: 28/03/2022 17:15).
If i create a data table in my apps, in data column, can I show only hour?
Thank you
@common_user
Yes, you can add a column to your table results for the Items property of the data table.
Ex. AddColumns(yourExistingItemsPropertyFormula, "_hour", Hour(yourDataColumn))
Then choose to display the _hour column in your datatable.
I hope this is helpful for you.
Hi @common_user ,
You can use the Hour() function for that:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-datetime-parts
Hi @RandyHayes , I try to modify formula. So I have just a little problem, I would to see 00:00 and 01:00 but I have a different result as you can see in the follow picture.
Do you know how can I correct this hour format?
With that method...change your formula in the Text property to:
Text(ThisItem.OraInizio, "hh:mm")
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 342 Super User 2026 Season 2
M Bilal Khan 283
Mohsin Ali 221
