PowerApps bug: formatting of integer leaves stray decimal point

This is an annoying bug, but fortunately no more than that.Steps to reproduce the bug

  1. Create a blank app
  2. 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

Leave a Reply

Your email address will not be published. Required fields are marked *