cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

web studio regionalisation in Edge vs Chrome

This isn’t urgent, just curious as I can work around it so long – but it’s really bugging me to know why it’s doing this!

 

While replying to a question on the forum, I discovered my Edge browser experience in web studio suddenly became regionalised to somewhere else.

This is evident in the formula syntax – list chaining uses ; instead of , which my region normally uses.

Something’s changed somewhere and I’m not sure if it was me that changed it, but I can’t see where or how.

 

Initially I was trawling through regional settings on my laptop (all correct), then in PA Admin and even Dynamics to try find the problem – but it all seems fine. The only two regions and languages I can see are English and the regions I've always used (SA and US).

Then I tried a different browser (Chrome) – and the regionalisation syntax is normal…


Edge - wrong

 

edgeSyntax.png

 

Chrome - correct

 

chromesyntax.png

 

This only started happening in the past couple of days – any ideas?

 

Kind regards,

 

RT

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: web studio regionalisation in Edge vs Chrome

Apparently it has to do with this update;

https://powerapps.microsoft.com/en-us/blog/international-region-updates-for-canvas-apps/

 

We really need a local PowerApps setting for locale so you're not locked into your OS or language settings when it comes to coding, but your own personal preference.  Please upvote this idea if you've come across this issue;

 

https://powerusers.microsoft.com/t5/PowerApps-Ideas/Set-the-decimal-separator-for-formulas/idi-p/251...

 

Thanks


RT

Super User
Super User

Re: web studio regionalisation in Edge vs Chrome

After much tinkering, I've managed to figure a few things out and get my syntax back Smiley Happy

 

Firstly, my assumption that Excel and PowerApps were tied to the same settings was incorrect.  Changing language configurations affected Excel, but did not affect PowerApps through Edge.

Secondly, depending on your version of Windows 10, the setting you're looking for sits under Privacy, not language:

language1.png

Toggling this off allowed me to revert my system to SA English with US English Number formatting, successfully forcing Edge (and therefore PowerApps) to use the correct decimal and list separators.

 

language2.png

As an aside, while the South African number official formatting IS actually spaces for thousands separator and comma for decimal separator, (one million = 1 000 000,00) almost 50 years of westernised-by-default computer interactions leaves us with a nation of tech-savvy people who are used to the US formatting (one million = 1,000,000.00) 

Right or wrong, it's still a good idea to let people choose based on preference - so go ahead and use this config to correct your syntax if you've got the same problem, but also upvote this idea to provide user-based syntax preferences for PowerApps.
https://powerusers.microsoft.com/t5/PowerApps-Ideas/Set-the-decimal-separator-for-formulas/idi-p/251...

Kind regards,

RT

6 REPLIES 6
Highlighted
Super User
Super User

Re: web studio regionalisation in Edge vs Chrome

Hi @RusselThomas 

To try and diagnose this, could you visit this page in Edge to see the locale details that it's sending?

http://www.localeplanet.com/support/browser.html

If you then open this page in Chrome, does it report the same information?

Super User
Super User

Re: web studio regionalisation in Edge vs Chrome

browserreg.png

 

Thanks @timl - left is Chrome, right is Edge.

 

Kind regards,


RT

Super User
Super User

Re: web studio regionalisation in Edge vs Chrome

Hi @RusselThomas 

Thanks for sharing that screenshot. I think what's happening here is that in Windows > Settings , your preferred language is set to English (South Africa) and that's the reason why Edge is picking up that locale.

 

image.png

 

If that's the case, you can fix this by adding English US and moving that to the top of the list.

If you don't want to make this system wide language change, the only way you appear to be able to make this change is through a registry change.

https://stackoverflow.com/questions/44536044/ie-11-and-edge-in-windows-10-doesnt-allow-to-change-lan...

 

Super User
Super User

Re: web studio regionalisation in Edge vs Chrome

Thanks @timl ,

 

So I discovered at my client today they have the same problem.  I doubt this is a coincidence - it seems more likely that something has changed to change our region syntax.  I'll check with some more people and try chase it up the chain from my side.

 

Kind regards,


RT

Super User
Super User

Re: web studio regionalisation in Edge vs Chrome

Apparently it has to do with this update;

https://powerapps.microsoft.com/en-us/blog/international-region-updates-for-canvas-apps/

 

We really need a local PowerApps setting for locale so you're not locked into your OS or language settings when it comes to coding, but your own personal preference.  Please upvote this idea if you've come across this issue;

 

https://powerusers.microsoft.com/t5/PowerApps-Ideas/Set-the-decimal-separator-for-formulas/idi-p/251...

 

Thanks


RT

Super User
Super User

Re: web studio regionalisation in Edge vs Chrome

After much tinkering, I've managed to figure a few things out and get my syntax back Smiley Happy

 

Firstly, my assumption that Excel and PowerApps were tied to the same settings was incorrect.  Changing language configurations affected Excel, but did not affect PowerApps through Edge.

Secondly, depending on your version of Windows 10, the setting you're looking for sits under Privacy, not language:

language1.png

Toggling this off allowed me to revert my system to SA English with US English Number formatting, successfully forcing Edge (and therefore PowerApps) to use the correct decimal and list separators.

 

language2.png

As an aside, while the South African number official formatting IS actually spaces for thousands separator and comma for decimal separator, (one million = 1 000 000,00) almost 50 years of westernised-by-default computer interactions leaves us with a nation of tech-savvy people who are used to the US formatting (one million = 1,000,000.00) 

Right or wrong, it's still a good idea to let people choose based on preference - so go ahead and use this config to correct your syntax if you've got the same problem, but also upvote this idea to provide user-based syntax preferences for PowerApps.
https://powerusers.microsoft.com/t5/PowerApps-Ideas/Set-the-decimal-separator-for-formulas/idi-p/251...

Kind regards,

RT

Helpful resources

Announcements
firstImage

PowerApps Monthly Community Call!

Join us next Wednesday for our Demo Extravaganza, October 16, 2019 8am PDT.

firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 115 members 3,846 guests
Please welcome our newest community members: