This is an annoying bug, but fortunately no more than that.Steps to reproduce the bug
- Create a blank app
- Create a label and set its Text property to:
Text(29, “[$-en-GB]#,##0.##”, “en-GB”)
[other locales such as “it-IT”, “es-ES” also give a similar error]
The label will show 29. with a decimal point at the end, whereas you would expect this to see only 29
Work-around
The following expression will check to see if MyNumber is not an integer, and only then will the decimal part of the formatting be added:
Text(MyNumber, “[$-en-GB]#,##0″&If(MyNumber<>RoundDown(MyNumber,0),”.##”), “en-GB”)
Reference
https://powerapps.microsoft.com/en-us/tutorials/function-text/
PowerApps version tested: 2.0.680