Hi,
I have a gallery and on each item I have the start time and end time as 2 text labels. However, it is displaying the date as "mm/dd/yyyy" but I would like it to display it as "dd/mm/yyyy". The current text code for the label is ThisItem.'Start Time' ('Start Time') is my column on the list. The date in the SharePoint list is also displaying it as "dd/mm/yyyy".
Thanks
Hi @SpongYe,
Thank you very much! Just one last question if that's ok, not a major thing but before when the date was wrong the time was 4:00 PM but now it's 04:00 PM for example, is it possible to remove that 0 if it's not needed? Just wondered if that's possible.
Thanks again for all the help!
Hi @SpongYe,
Thank you, that's worked. If I would like to add AM or PM on the end, is that possible?
Thanks
Hi @BS10
You need to edit the format:
Text(DateValue(ThisItem.'Start Time'), "dd/mm/yyyy hh:mm")
------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.
If you like my response, please give it a Thumbs Up.
Hi @poweractivate,
Thanks for the fast response, this has worked thank you but I also have the time in the column too. Is it possible to include this as well?
Thank you!
Try this:
Text(DateValue(ThisItem.'Start Time'), "dd/mm/yyyy")
------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.
If you like my response, please give it a Thumbs Up.
To format the date displayed in your Power Apps gallery label as "dd/mm/yyyy," you can use the Text function to convert the date value to a formatted string. Here's how you can modify your label's text property to achieve the desired formatting:
Text(ThisItem.'Start Time', "dd/mm/yyyy")
In this formula, the Text function takes two arguments: the date value you want to format (ThisItem.'Start Time') and the format string "dd/mm/yyyy".
If this helped and resolves your issue can you leave a thumbs up and mark this as the solution?
Many Thanks
Andrew
To change the date format for the text labels in your gallery, you can use the Text
function along with the desired format string in Power Apps.
For your 'Start Time' label, the formula should be:
Text(ThisItem.'Start Time', "[$-en-GB]dd/mm/yyyy")
The [$-en-GB]
part is a locale specifier that follows the Great Britain format for the date. You can adjust this to other locales if needed.
For your 'End Time' label, you would use a similar formula:
Text(ThisItem.'End Time', "[$-en-GB]dd/mm/yyyy")
These formulas should display the date as "dd/mm/yyyy" as you wanted.
See if it helps @BS10
mmbr1606
41
Super User 2025 Season 1
WarrenBelz
37
Most Valuable Professional
MS.Ragavendar
34