How to manage number patch with decimal numbers from different language

[Sesese]

Hi guys,

I've an issue with patching number with decimal number and different devices with different languages.

I have bunch of devices with italian language and others with english language and when I'm trying to patch numbers with decimal values it may happen that they can be written with ","  or "." before decimal number.

For example I have two number written as 8.05 and 8,05; the issue here is that when I try to read data I have these numbers showed as 805 and 8.05 in device 1 and  8,05 and 805 in devices two. How can I standardize this issue because in this way I'm not able to show data properly considering the different devices and can't do math formula because they go totally far from the reality

Many thanks 

[v-chengfen-msft · Accepted solution]

Hi  @Sesese ，

Do you want to parse numeric text based on the user's language?

If so, please try this formula:

Value( InputText ,Language() )

Language():

Value():

I think these links will help you a lot:

Value function in Power Apps - Power Platform | Microsoft Learn

Language function in Power Apps - Power Platform | Microsoft Learn

Best Regards

Cheng Feng