cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sesese
Helper III
Helper III

How to manage number patch with decimal numbers from different language

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 

1 ACCEPTED SOLUTION

Accepted Solutions
v-chengfen-msft
Microsoft
Microsoft

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

vchengfenmsft_1-1666085568356.jpeg

vchengfenmsft_0-1666085568354.jpeg

Best Regards

Cheng Feng

View solution in original post

1 REPLY 1
v-chengfen-msft
Microsoft
Microsoft

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

vchengfenmsft_1-1666085568356.jpeg

vchengfenmsft_0-1666085568354.jpeg

Best Regards

Cheng Feng

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,444)