Change date format from mm/dd/yyyy to dd-mm-yyyy in Powerapps in teams

Like (2) Share

Report

Posted on 16 Aug 2021 14:05:25 by Lars1990

Hi all,

I am trying to change the date format of a date picker field in Powerapps in Teams. I tried these two methods:

- Change the ContectLanguage property from "" to "nl-NL"

- Change the value property from Parent.Default to Text(Parent.Default, "dd/mm/yyyy")

Unfortunatly this doe not work.

Does anyone know how to solve this?

KR,

Lars

All responses (24)

Answers (1)

Suggested answer

Graeme_NZ 18 on 20 Sep 2024 at 02:57:29

Like (2)

Report

Change date format from mm/dd/yyyy to dd-mm-yyyy in Powerapps in teams

Since you can no longer access the classic interface to do this, the better option is to update the Text property for the datacard. It will default to something like:

ThisItem.Date

Click in the function box and type:

Text(ThisItem.Date,"dd/mm/yyyy")

You can also use other date formats, like "dd mmm yy" which will display as 20 Sep 2024

Cheers, Graeme_NZ
mrdickiePA 11 on 05 May 2024 at 14:53:48

Like (1)

Report

Re: Change date format from mm/dd/yyyy to dd-mm-yyyy in Powerapps in teams

Another 'classic' example (pardon the pun) where Microsoft provide you with a really cool app but don't quite get the little bits right. I mean, why on earth would you not have a format property on the datepicker? Maybe I'm missing something technically important but it shouldn't be this hard to get the right format you want. Besides the whole international date zone thing, what if you wanted to show it like Mon, 4th May or even May 4th? Stupid. 🙂
Tully 18 on 04 Oct 2023 at 02:59:30

Like (3)

Report

Re: Change date format from mm/dd/yyyy to dd-mm-yyyy in Powerapps in teams

I have found a working solution (workaround?) as none of the ones suggested here worked for me or exist in the current version of Power Apps.

Go to Settings > Upcoming features and enable the preview "Modern controls and themes" feature. When inserting controls there will now be a Classic and Modern tab. Add the "Date picker" control from the Modern tab and change the format to LongAbbreviated, which will display dates as "4 Oct 2023" instead of "11/4/2023"

Pretty annoying that such a basic feature was removed and a preview feature has to be used as a workaround. Microsoft, not everyone lives in the US...
ElroyAirMed 40 on 17 Mar 2023 at 07:30:35

Like (2)

Report

Re: Change date format from mm/dd/yyyy to dd-mm-yyyy in Powerapps in teams

It's all in the name - "Power" Apps. It baffles me that Microsoft has the audacity to call it such.
KrAck 54 on 15 Mar 2023 at 10:19:51

Like (2)

Report

Re: Change date format from mm/dd/yyyy to dd-mm-yyyy in Powerapps in teams

Still baffled that in 2023 you still cannot do something so simple in PA for Teams. If everybody suggests to use make.powerapps.com or the classic controls, why does Ms than even bother to have a PA for Teams environment.

And nice to see that there are workarounds, but this really should be standard functionality IMHO in this time and age.
Anonymous_Hippo 1,247 Super User 2024 Season 1 on 09 Aug 2022 at 15:06:56

Like (2)

Report

Re: Change date format from mm/dd/yyyy to dd-mm-yyyy in Powerapps in teams

Hello All,

I have added this as an idea. Please vote if you think that this adds value to PowerApps

https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Add-quot-Format-quot-property-for-date-picker-control-in/idi-p/1709001#M36753
ganesh131982 89 on 22 Jun 2022 at 00:41:37

Like (2)

Report

Re: Change date format from mm/dd/yyyy to dd-mm-yyyy in Powerapps in teams

I found @AlexKeil 's suggestion worked for me.

https://powerusers.microsoft.com/t5/Building-Power-Apps/How-do-I-get-my-dataform-to-display-dates-in-DD-MM-YYYY-format/m-p/173082#M57758
ganesh131982 89 on 21 Jun 2022 at 23:00:02

Like (1)

Report

Re: Change date format from mm/dd/yyyy to dd-mm-yyyy in Powerapps in teams

Hello,

I'm unable to find the classic controls toggle button under the Experimental tab in Upcoming features.

I'm trying update the date field for a date column I'm pulling in from SharePoint.
BetterKnowledge 3 on 12 May 2022 at 00:49:19

Like (1)

Report

Re: Change date format from mm/dd/yyyy to dd-mm-yyyy in Powerapps in teams

So easy! Thanks.
Vitss 315 on 20 Apr 2022 at 12:58:53

Like (4)

Report

Re: Change date format from mm/dd/yyyy to dd-mm-yyyy in Powerapps in teams

@AndrewS I used the 'Teams' datepicker in a Canvas app outside Teams, to format the displayed date I used a label on top of the datepicker showing the formatted Date as wanted using Text(DataCardValueXX.Value, "dd/mm/yyyy").
The Label is just masking the datepicker so NoOneKnows.