Good evening everyone,
I would like in my PowerApps application to be able to change the display of "DistanceParcourue" so that there is no number behind the comma.
This data comes from a SP list and a calculated value column of type number with decimal places set to 0.
I tried several things like:
Text (Parent.Default; "[$ - fr] #")
But nothing helps.
Thank you for your help.
Solved! Go to Solution.
if the calculated column has the format of #.# instead of #,# then this might work:
Round( Value( Substitute(ThisItem.DistanceParcourue;".";",") ) ; 2 )
Hi @FJA The reason for this is the combination of using a calculated column, along with a French locale where semi-colon is the decimal separator, rather than a comma.
There are more details here.
In addition to @Coopedup's advice, you can also try using the Round function.
Round( Value(ThisItem.DistanceParcourue), 2 )
Hi @Coopedup ,
Thaks for your help.
But your solution doesn't work. (see the joined picture).
indeed, if I put this function, I no longer have any result displayed
Thanks and have a good day
it actually seems like it works. It looks like you don't have an error any more but a result of "0" instead.
What is the actual number behind ThisItem.DistanceParcourue? Maybe the number is so small that the Round function rounds it down to 0.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.