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,
Have you tried to use the below formula on the Patch function?
If this does not work, then you might want to use the workaround:
If(Language()="fr-FR",Substitute(TextInput1.Text, ",", "." ),TextInput1.Text)
the workaround works. Unfortunately it opens an entirely new array of issues
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.
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.
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?
Join us next Wednesday for our Demo Extravaganza, October 16, 2019 8am PDT.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
Continue your learning in our online communities.
Features releasing from October 2019 through March 2020
Coming to a city near you
Fill out a quick form to claim your user group badge now!
Connect, share, and learn with your peers year-round
Register by September 5 to save $200