cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
shimauk
Level: Powered On

App used in multiple countries ( decimal separators )

Hi ,

 

I'm building an app that is going to be used both in France and UK.

In france they use comma as decimal separators and in Uk we use full stops. 

My issue is that if french user inputs a value in a text field with comma and I use a flow or patch function to patch it to the database , the db will rewrite the number as it is coming in UK format. e.g. French user inputs 2,45 and Db stores 245.

There is a language tag in value function Value(Textinput.Text,"fr-FR") but that doesnt help as this only works if you're inputing full stops in france or commas in the UK which will never be the case.

 

Thank you for your help,

Peter

6 REPLIES 6
Community Support Team
Community Support Team

Re: App used in multiple countries ( decimal separators )

Hi @shimauk,

 

Have you tried to use the below formula on the Patch function?

 

Value(TextInput1.Text,Language())

 

 

If this does not work, then you might want to use the workaround:

 

If(Language()="fr-FR",Substitute(TextInput1.Text, ",", "." ),TextInput1.Text)

 

Regards,

Mona

 

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
shimauk
Level: Powered On

Re: App used in multiple countries ( decimal separators )

@v-monli-msft

 

Thank you,

 

the workaround works. Unfortunately it opens an entirely new array of issues Smiley Very Happy

 

I'm now able to upload correct format from both france and uk. The issue now is that when I subsequently collect data from source table i'm not able to use the data for any calculations ( when using french language ) as it cant sum up 16.5 + 20 ( only 16,5 + 20 ). 

I tried something like Substitute(Collection.Column,".",",") but that didnt do anything.

 

Cheers,

Peter

PowerApps Staff CarlosFigueira
PowerApps Staff

Re: App used in multiple countries ( decimal separators )

Which connector are you using that has this problem? We have a bug with CDS that has this symptom (decimal separator being ignored for locales where the separator is ',') - and this bug should be fixed by next week.

 

I was able to reproduce this issue with CDS, but with SQL Server and SharePoint I'm not seeing it.

PowerApps Staff CarlosFigueira
PowerApps Staff

Re: App used in multiple countries ( decimal separators )

Just to update this thread - I tried the same scenario yesterday, and it worked. Please let us know if this is not the case.

alex216
Level: Powered On

Re: App used in multiple countries ( decimal separators )

Hi, have you ever resolved this issue? I am facing a similar problem with users using a comma or a point as a decimal sign with unpredictable results.
MihirY
Level 8

Re: App used in multiple countries ( decimal separators )

I am also having similar issue. My formula as below 

If(Value(TextInput1.Text,"en-US")>0,"$"&Text(Value(TextInput1.Text,"en-US"),"[$-en-US] ###,##0.00"),"$" &Text(0,"[$-en-US] ###,##0.00"))

@CarlosFigueira are you referring to same issue or it is different?

Helpful resources

Announcements
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

Top Kudoed Authors
Users Online
Currently online: 198 members 5,055 guests
Please welcome our newest community members: