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 Name||Anti Dumping||Import Duties||Harbour Handling|
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.
Solved! Go to Solution.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Join us on June 28 for our monthly User Group leader call!
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.