Change Date & Time Format on Gallery Text Labels

(1) Share

Report

Posted on by BS10

658

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

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

poweractivate 11,078 Most Valuable Professional on at

Like (0)

Report
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

Was this reply helpful? Yes No
AndrewR1 1,572 Moderator on at

Like (0)

Report
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

Was this reply helpful? Yes No
SpongYe 5,603 Super User 2025 Season 2 on at

Like (0)

Report
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.

1 people found this reply helpful.

Was this reply helpful? Yes No
BS10 658 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Verified answer

SpongYe 5,603 Super User 2025 Season 2 on at

Like (1)

Report
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.

Was this reply helpful? Yes No
BS10 658 on at

Like (0)

Report

Hi @SpongYe,

Thank you, that's worked. If I would like to add AM or PM on the end, is that possible?

Thanks

Was this reply helpful? Yes No
SpongYe 5,603 Super User 2025 Season 2 on at

Like (2)

Report
Hi @BS10

Then you AM/PM at the end
Text(DateValue(ThisItem.'Start Time'), "dd/mm/yyyy hh:mm AM/PM")

Was this reply helpful? Yes No
BS10 658 on at

Like (0)

Report

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!

Was this reply helpful? Yes No