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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / PowerApp Calculations ...
Power Apps
Answered

PowerApp Calculations Global not working properly

(1) ShareShare
ReportReport
Posted on by 80

 I am from NLD and I've got a PowerApp which has a small calculation. Price per piece * Qty * Currency Conversion.

In the app is a Currency conversion (which is located in a Sharepoint table) with values like 1.06, 0.93, etc...

Its from EURO > Dollar etc... Now I've got a colleague in another country in East Europe. He gets an error with the conversion. 1.06 is not recognized as a number and the calculation gets in error somehow. 

In the NLD only a number with . (dot) is allowed in PowerApps calculations, so if i would use 1,06 (with komma) the app would just read 106 and the result of 500 * 100 * 1,06 would be 5 300 000 instead of the real result of 53 000. (my colleague would get 53 000 with this calculation and NOT an error.)

 

 Is there any way to set a fixed language for an application instead of using the language per user? 

Or are there other solutions for this problem? I can't think of one yet and also can't find it on the big web.

JoostCuppes_0-1703168012547.png

 

Categories:
  • tareqrosul Profile Picture
    164 on at

    Have you tried something like this ?

    500 * 100 * Value(Substitute("1,06", ",", "."))
  • Verified answer
    v-bofeng-msft Profile Picture
    Microsoft Employee on at

    Hi @JoostCuppes ,

     

    Is there any way to set a fixed language for an application instead of using the language per user? 

    Yes, please try:

    vbofengmsft_0-1703211876519.png

     

    Value("1,06","da")

    I think this link will help you a lot:

    https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-value

    vbofengmsft_0-1703211986526.png

     

     


    Best Regards,
    Bof

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 411 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 338

#3
WarrenBelz Profile Picture

WarrenBelz 256 Most Valuable Professional

Last 30 days Overall leaderboard