Announcements
Hello, I have Due Time string column that shows military hours, how do I show this as ShortTime in my Gallery?
I tried this by Text((ThisItem.'Due Time'),ShortTime) but the format did not change and no indication on syntax error as well.
Any ideas?
@Anonymous
Consider the following change to your formula:
Text(DateTimeValue(ThisItem.'Due Time')),ShortTime)
If your Due time is in text format as you mentioned, you need to first convert to a datetime object, then apply the text format.
I hope this is helpful for you.
Hi @RandyHayes I am getting unexpected characters in comma before ShortTime odd. (,ShortTime).
Sorry...typo:
Text(DateTimeValue(ThisItem.'Due Time'), ShortTime)
Hi @RandyHayes , thanks I should have caught that as well. 🙂
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.
WarrenBelz 416 Most Valuable Professional
11manish 205 Super User 2026 Season 2
MS.Ragavendar 128 Super User 2026 Season 2