Unanswered

Formula and decimal point incompatibility of my app from my phone

(0) Share

Report

Posted on by LezliGomez

Good afternoon to everybody!

I have a problem with an addition and subtraction formula in my app, when I test it on the web where I develop the app everything works correctly (photo1) but when I test it on my cell phone (android) the formula addition does not work correctly. I have noticed is that it does not recognize the decimal point in the values that I add (photo2 and photo 3), however, on the web all the values entered with decimal are addition correctly.

Photo 1 (app from the web):

Photo 2 (app from my telephone):

Photo 3 (app from my telephone):

Please, if someone can help me with this, I already tried the text formulas, ###. 00, change region es-ES but it doesn't work.

The app would be used in Peru - South America, so I don't know if it's a cell phone configuration issue.

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @LezliGomez ,

In general, this issue is due to the region/language difference between devices.

To unify the format, please try to use Text function, and set the Result language tag to output the desired format in specific region/language.

Syntax:

Text( NumberOrDateTime, CustomFormat [, ResultLanguageTag ] )

For further assistance, please share your code.

Sik

Was this reply helpful? Yes No
LezliGomez 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-siky-msft,

Thanks for your answer! I have followed your recommendation but it still does not recognize the decimal point in my cell phone, I have already made the change in all the fields where decimal values are entered and also in the sum formula, but without success, this is the sum formula:

Text(Value(Sum(Filter(Hdepositos,Inspector=TextInput2.Text),Monto)),"[$-es-ES]###.#","es-ES")
I hope you can help me, thank you!

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @LezliGomez ,

What is the default language setting of your PowerApps Studio/Browser? What is the final output you want?

If you want that a dot "." is used as decimal separator, please try this:

Text(Value(Sum(Filter(Hdepositos,Inspector=TextInput2.Text),Monto),"en-GB"),"###.#","en-GB")

If this still doesn't make sense, please share more information about your app.

Sik

Was this reply helpful? Yes No
LezliGomez 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-siky-msft ,

I followed your steps but unfortunately it remains the same, it does not recognize the decimal point, that is, the point appears but it does not in the correct place, I am sending you the corresponding photos.

By default my Power Apps develoverps is in English, and the cell phones where the app would be used are in Spanish (United States), I don't know if that's the problem.

Thank you!

Updated formula: Text(Value(Sum(Filter(Hdepositos,Inspector=TextInput2.Text),Monto),"en-GB"),"[$-en-GB]###.#","en-GB")

Photo from web

Photo from telephone

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @LezliGomez ,

What is the region format of backend data 'Monto'? Please share some sample data/

In my test based on your scenario, the following code works consistently, if the decimal point of sum value is dot.

Text(Value(Sum(Filter(Hdepositos,Inspector=TextInput2.Text),Monto)),"[$-en-US]###.0","en")

In addition, please make sure the latest version of App has been published, to keep consistency between mobile and browser.

Sik

Was this reply helpful? Yes No
LezliGomez 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, @v-siky-msft ,

Already tried with your formula and on the web everything is fine but the decimal point is still not correctly on the cell phone.

The format of the amount field is: (,) thousands separator and (.) as decimal point.

I attach the excel where all the information that is entered in the app is saved
web:
app:
Thank you very much for your help!

Power App - Lezli...

Was this reply helpful? Yes No
Motion 69 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Everyone, any solution to this issue because I am have same problem

I tried these two different formulas

Round(Parent.Default,2)
Text(Parent.Default*1,"[$-de-DE]#.0")

but the decimal place is still messed up on my tablet and when I open the power in Microsoft Teams.

Any help, suggestion or solution would be appreciated.

Thanks

Was this reply helpful? Yes No