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
