web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Bug with locale in the...
Power Apps
Unanswered

Bug with locale in the date selector / date time labels

(0) ShareShare
ReportReport
Posted on by 287

Hello Power Users,

 

I'm not sure where my question fits so I'm posting it here to see if anyone has some kind of logical answer to this. For some reason the locale in my organization is different for some users. We are using the app from Finland and the locale here is formatted by dd.m.yyyy.

 

One of the users has his region and timezone set in his machine to Finland but the Power App is showing the locale in the following format:

locale.png

This can easily cause a mix-up with reading the date as they are formatted with m/d/yyyy instead of dd.m.yyyy.

 

Me and this other user are in the same timezone and using exactly the same region settings but for me the time is displayed like this:

locale2.png

 

As you can see, there's huge differences with the hours and minutes as well. How is the locale formatted and is there a fix for this? Does it have something to do with your machine's locale settings?

 

Thanks, 

 

Ville

Categories:
  • rizkyaditya Profile Picture
    292 on at

    Hello @VilPel ,

     

    Rather than doing repeatable job of formatting each user's machine locale setting, you can try this in your label that showing the date :

     

    Text(yourDataHere, "dd.m.yyyy")

     

    It will show the date using the format you use in Finland which is dd.m.yyyy.

    I hope this helps.

  • VilPel Profile Picture
    287 on at

    That could be one solution but how do we show the correct way of formatted date to someone in the US/UK? I don't want the app to be for Finnish locale only

  • rizkyaditya Profile Picture
    292 on at

    Hello @VilPel ,

     

    From my point of view, to easily define where someone is located is you need to have additional column in your database to state their location.

    And then use the previous way to format date with some little modification like this :

     

    Text(yourDataHere,
    Switch(userLocaleColumn,
    "US", "mm-dd-yyyy",
    "UK", "dd/mm/yyyy",
    "Fin", "dd.m.yyyy"))

     

     

    That will show the date based on user locale.

  • VilPel Profile Picture
    287 on at

    Thank you for your suggestion.

     

    What kind of column type would this be? I am using Dataverse and the common data model "Users" -table. Also, would I need to type like 100+ rows of code for each date label to identify the correct date format?

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 220 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 194 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 150

Last 30 days Overall leaderboard