cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Thomas2103
New Member

Swiss number format for Microsoft Power Apps

Hi,

 

we are just developing an App based on Microsoft Power Apps where we try to insert currency values according to the Swiss currency format which is "." instead of "," as decimal delimiter and ' as delimiter before 1000. 

In the app it works, but as soon as one inserts the value into SQL database, it disturbs it. Dependend on the phone that used the app, it woulds sometimes, use a "." and sometimes ",".

 

There was a way where we could make it work on Iphone but not on Samsung, and a way where it would work on Android but not on Iphone. Sometimes two different Ipone would not work the same(dependant on the settings of the Iphone)

 

So far we found no solution yet for this requirement than using a workaround which means insert the values muliplied by 100 without delimiter - which is divided by 100 before insert in SQL database then.

 

My iphone settings are region = Switzerland 

 

Someone who has any idea to solve this.

 

Thanxs in advance for your support

2 REPLIES 2
timl
Super User
Super User

Hi @Thomas2103 

What's the data type of column in SQL that you're using to store the currency value? So long as it's a numeric column, the language/locale of the device shouldn't cause a problem.

I will look into this solution and try it next. Thank you for the information!

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (2,893)