Number formats in Apps (mobile) - calculations

(0) Share

Report

Posted on by Yakimo

Hi PowerApps community

I have some problems how PowerApps interpretes fraction numbers based on language on the iPhone device

Situation: I have simple App, that should show different colors based on definition in my TextInput

So - in valGreen.Default I put 0.985 - as seen on the pictures below

Later, on Fill I have the following formula:

If(Value(txtDaily.Text)>=Value(valGreen.Text),Green,If(Value(txtDaily.Text)>=Value(valYellow.Text),Yellow,Red))

Everything works fine on iPhone with English settings

But i noticed, that if the settings are Danish, it doesn't work as expected. Analysing that, I realised that in Danish 0.985 is not fractional number, because in Danish decimal sign is comma, not dot

In fact if I run the App and change my TextInput from 0.985 to 0,985 (note the comma) - it start showing correctly colors

My question is - how to put the default correct fraction number in my TextInput, so it works on both English/Danish devices?

Regards,

Yakimo

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (2)

Sort by

hpkeong 2,944 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi

May this link, under Global Apps section and custom format language placeholder

https://powerapps.microsoft.com/en-us/tutorials/function-text/

gives you a better answer?

Hope it helps, TQ

Was this reply helpful? Yes No
Yakimo 91 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @hpkeong

I couldn't quite get it
Shall I type in valGreen.Default Text( 0.985, "[$-en-US]", "en-US" )
so the danish iPhone can make the comparison correct?

Unfortunatelly I do not have around Danish iPhone, some of my colleagues have, and I cannot test it right away

Thanks
Yakimo

Was this reply helpful? Yes No
Verified answer

AndyPennell Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
You have the right idea, but a better solution would be
Text(0.985,"[$-en-US]##.000")
depending on the range of numbers you need to support. This says "interpret the period in the format string as a decimal point", then "convert to a string in the user's locale" (Danish in your case).

Was this reply helpful? Yes No
Verified answer

hpkeong 2,944 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Yakimo

@AndyPennellis correct.

Please amend accordingly.
TQ

Was this reply helpful? Yes No
Yakimo 91 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @hpkeong, @AndyPennell

Thanks both for suggestions.
I would like to test @AndyPennell's suggestions
Will do that right away tomorrow in the office, where I have colleagues with Dansih iPhones
Before that I cannot amend, sorry

Regards,
Yakimo

Was this reply helpful? Yes No
Yakimo 91 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the solution, @AndyPennell
It solved my issues

regards,
Yakimo

Was this reply helpful? Yes No
jlke-as 130 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi... I have a more or less similar issue...
I'm from Denmark, so I would like to use comma to separete a fraction number... I would assume that there was a setting somewhere in Power Apps to make Power Apps calculate in "my way..." - but I cannot find this kind of setting any where... Can you help me?
In a table I have some numbers (hours) - and I would like to the user to split the hours into groups. In this process the user should see:
1) see the total figure to be split (in this case 7 hours)
2) insert a figure to dedicate to a group (as a default it should show the remaining hours, that needs to be dedicated to a group)
3) see the amount of hours that have been split so far...
As you can see, I have managed to all figures shown with comma as separator - but the "15,00" and "25,00" has actually been add as "1,5" and "2,5" (as we do fractions in Denmark)... But Power Apps understands it as "15" and "25" and therefore sums it up to "40" instead of "4" (so now Power Apps thinks that have split 33 hours more than needed)...
How can I get Power App to do calculations with comma as separator?

wkr Jørgen

Was this reply helpful? Yes No