web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : QwWh5zAtB57fBSKkKZrFUI
Power Apps - Building Power Apps
Answered

How to manage number patch with decimal numbers from different language

Like (0) ShareShare
ReportReport
Posted on 17 Oct 2022 14:59:46 by

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 

Categories:
I have the same question (0)
  • Verified answer
    v-chengfen-msft Profile Picture
    on 18 Oct 2022 at 09:34:13
    Re: How to manage number patch with decimal numbers from different language

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 686 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 433 Super User 2025 Season 2

#3
wolenberg_ Profile Picture

wolenberg_ 266 Moderator

Last 30 days Overall leaderboard
Loading complete