cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
marcdb
New Member

Decimals and regional settings

Hello,

 

Today I gave my first try at creating a Power App. Quite a simple one, enter a value in a field, choose an option from the dropdown, then get some numbers (percentage values) from an Excel table an calculate some figures.

I got the functionality working within 2 hours, Power Apps is easy to use. BUT...... I can 't get the decimals to be shown properly on different devices because of different localisation settings. I've already spent 5 hours trying and searching for a solution, but every solution only seem to get the required result on 1 device.

 

My excel sheet contains percentage values, entered as decimals. I'm The Netherlands and using computer with language EN and decimal sign , (comma). Values are formatted as General/Numbers

 

Supplier NameAnti DumpingImport DutiesHarbour Handling
Supplier 1000,064
Supplier 20,54900,07
Supplier 3000,012
Supplier 40,56900,012
Supplier 5000,019

 

So Supplier 2 Anti-Dumping = 54,9%

 

When showing the values in Power App on a canvas on my computer with this, it's showing fine and output will be 0.549 (with dot)

 

 

 

 

LookUp(Percentages,'Supplier Name'=Text('dd.Supplier'.Selected.'Supplier Name'),'Anti Dumping')

 

 

 

 When I make a calculation it's also fine and will show 1549.0

 

 

 

## 'inp.GoodsValue' = 1000

Round('inp.GoodsValue'*(LookUp(Percentages,'Supplier Name'=Text('dd.Supplier'.Selected.'Supplier Name'),'Anti Dumping')),0)

 

 

 

 

However when I open the app on my iPhone (Dutch language settings) the numbers that are shown and calculated are wrong:

Showing the lookup value will give me 549000 and the calculation will give me 549000000

 

This is showing fine on my computer, but not on iphone:

 

 

 

Text(LookUp(Percentages,'Supplier Name'=Text('dd.Supplier'.Selected.'Supplier Name'),'Freight Cost')*100,"##.#"&"%")

 

 

 

To show the value as a percentage for example, I've tried this, but it's jus showing ,%, no digits.

 

 

 

 

Text(LookUp(Percentages,'Supplier Name'=Text('dd.Supplier'.Selected.'Supplier Name'),'Freight Cost')*100,"##,#"&"%","nl-NL")

 

 

 

 

We're an international company and I use various languages. How can I make the decimals to be shown/calculated in a uniform way? I've read the help sections for text and value and global app, but so far no solution found, also not here on the board. 

 

Setting the language to  "nl-NL" or "en-US" part also doesn't make sense to me.  Do I need to set this for every language in our company? Is Power Apps that dumb?

 

Hope someone can help.

1 ACCEPTED SOLUTION

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

Hi @marcdb :

Please try:

Value(LookUp(Percentages,'Supplier Name'=Text('dd.Supplier'.Selected.'Supplier Name'),'Anti Dumping'),"En")

 and check if this problem is solved.

Best Regards,

Bof

View solution in original post

2 REPLIES 2
v-bofeng-msft
Community Support
Community Support

Hi @marcdb :

Please try:

Value(LookUp(Percentages,'Supplier Name'=Text('dd.Supplier'.Selected.'Supplier Name'),'Anti Dumping'),"En")

 and check if this problem is solved.

Best Regards,

Bof

marcdb
New Member

@v-bofeng-msft Thanks, that solved it. 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (2,968)