Skip to main content

Notifications

Community site session details

Community site session details

Session Id : h16U+2ZmYwxp12dBHtx80V
Power Apps - Building Power Apps
Answered

Change Date & Time Format on Gallery Text Labels

Like (1) ShareShare
ReportReport
Posted on 30 Aug 2023 15:37:25 by 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:
  • BS10 Profile Picture
    658 on 30 Aug 2023 at 16:03:23
    Re: Change Date & Time Format on Gallery Text Labels

    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!

  • SpongYe Profile Picture
    5,580 Super User 2025 Season 1 on 30 Aug 2023 at 15:58:41
    Re: Change Date & Time Format on Gallery Text Labels

    Hi @BS10 

     

    Then you AM/PM at the end

    Text(DateValue(ThisItem.'Start Time'), "dd/mm/yyyy hh:mm AM/PM")​
  • BS10 Profile Picture
    658 on 30 Aug 2023 at 15:55:37
    Re: Change Date & Time Format on Gallery Text Labels

    Hi @SpongYe,


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

     

    Thanks

  • Verified answer
    SpongYe Profile Picture
    5,580 Super User 2025 Season 1 on 30 Aug 2023 at 15:48:21
    Re: Change Date & Time Format on Gallery Text Labels

    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.

  • BS10 Profile Picture
    658 on 30 Aug 2023 at 15:47:11
    Re: Change Date & Time Format on Gallery Text Labels

    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!

  • SpongYe Profile Picture
    5,580 Super User 2025 Season 1 on 30 Aug 2023 at 15:44:29
    Re: Change Date & Time Format on Gallery Text Labels

    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.

  • AndrewR1 Profile Picture
    1,572 Super User 2025 Season 1 on 30 Aug 2023 at 15:44:04
    Re: Change Date & Time Format on Gallery Text Labels

    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

     

  • poweractivate Profile Picture
    11,078 Most Valuable Professional on 30 Aug 2023 at 15:43:10
    Re: Change Date & Time Format on Gallery Text Labels

    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 

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.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
mmbr1606 Profile Picture

mmbr1606 41 Super User 2025 Season 1

#2
WarrenBelz Profile Picture

WarrenBelz 37 Most Valuable Professional

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 34

Overall leaderboard