cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver I
Resolver I

Language Locale Problem

I am trying to buld an app to log holidays for users but every time I load up the web designer it forces en-US language and locale.

I really want the date pickers to show dd/mm/yyyy date format but because of en-US it is always mm/dd/yyyy

I have windows 7 set to english UK with US uninstalled.

I have chrome with only english UK installed

I have tried IE 11.

I have checked my user agent Locale in other places and for both browsers it always says en-GB.

I have tried adding ?l=en-GB to the address but that doesn't work either.

 

Why would powerapps be stuck on en-US and forcing mm/dd/yyyy format even though everywhere it could look for a locale is set to en-GB.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

TL;DR - Studio on Windows does not have explicit support for "en-GB", but it does support using it in Text/Value functions (though not DatePicker, yet). This is why Language() returns "en-US" in Britain.

 

Full version:

The locale-choosing logic is, um, interesting, and varies highly per OS/Browser, out of sad necessity. In the Studio case it is slightly weirder, as Studio is not localized for en-GB (e.g. see "Color"), but I did add "en-GB" to the list of runtime locales (as I am an ex-pat Brit and I wanted an easy test-case when I wrote the globalization code).

 

In the v640 timeframe the DatePicker can take a locale string, which will solve your problem.

View solution in original post

5 REPLIES 5
Highlighted
Power Apps
Power Apps

In the near future the Date PIcker will have a much easier and more flexibile globalization story. However right now it will use the users locale (determined by various browser-and-OS-specific rules). What result does the Language() function display on these systems? If it says "en-GB" then the date picker should be using British date formatting.

Highlighted

Currently the result of Language() is en-US however in chrome the result of navigator.language in the console is en-GB.

 

I have noticed that this is only the case while editing the power app.

If I am just running the powerapp in the browser is shows as en-GB.

 

It seems stange the the editor would see the locale differenlty from the editor.

Highlighted

TL;DR - Studio on Windows does not have explicit support for "en-GB", but it does support using it in Text/Value functions (though not DatePicker, yet). This is why Language() returns "en-US" in Britain.

 

Full version:

The locale-choosing logic is, um, interesting, and varies highly per OS/Browser, out of sad necessity. In the Studio case it is slightly weirder, as Studio is not localized for en-GB (e.g. see "Color"), but I did add "en-GB" to the list of runtime locales (as I am an ex-pat Brit and I wanted an easy test-case when I wrote the globalization code).

 

In the v640 timeframe the DatePicker can take a locale string, which will solve your problem.

View solution in original post

Highlighted

Hi

 

Really struggling to get my head around the US only date format problem here. I have an app which need to calculate days remaining to the end of year. I use the format string "dd/mm/yyyy" with ther date picker to fix that problem. Running  the app within studio gives the correct value of days remaining 287. However running it on IOS gives the wrong value 846. The data is coming from a Sharepoint list and the date values are in UK format and all is well there.

 

I can't see where to change the date data or format string to fix the arithmetic.

 

Also can't understand why something so basic hasn't been fixed yet.

 

Charlie

Highlighted

Follow-up to previous port.

 

Logged into PowerApps today and all the UK style date calulations are displaying the correct answers!

 

Don't understand what changed - but hopefully all sorted now!

 

Charlie

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (8,997)