Remove trailing zeros on mobile

[Anonymous]

Hello everyone

I am making a time reporting application, with the goal of employees of a company being able to report how much time they've spent on a project on a daily basis. The 'time cards' are stored in a sharepoint list. 

Everything works as expected; except for the fact that the trailing zeros of my calculated 'total' column remain when accessing the application on my smartphone.

Below is a screenshot of the column 'total' on my smartphone version of the app.

I use the function Abs(ThisItem.Totaal) to show the item. When using Text(ThisItem.Totaal, "0.0") or simply Value(ThisItem.Totaal), the result remains the same.
Yet this is how the number looks when opening the application on desktop:

 

I get this number from the sharepoint list that the timecards get saved to. "Totaal" is a calculated column, adding together all the individual columns of the week-days. "Totaal" is a number-field.

Is there a way through which I can assure that the number shown on the mobile version of the app is the same as the one shown on the desktop version ? 

 

[Pstork1]

not sure why you are only seeing the trailing zeros on the mobile.  Given the formulas you are using it should show up on all platforms.  To remove the trailing zeros you should be using the following Text() function to format them.

Text(ThisItem.Totaal, "0.#") 

The '0' character in the formatting will show any digit or a Zero.  The '#' will only show any actual number.  Leading and trailing zeros will be removed.

After changing the formula make sure you save and publish.  If you don't publish the app won't be available for update on the mobile device.

[timl]

Hi @Anonymous 

The cause of this will be a combination of two things.

There is a problem where SharePoint does not format calculated columns correctly. To remove the decimal places, a workaround you can try is to use the Round function instead, like so.

Round(
      Value(ThisItem.Totaal),
       0
)

There are more details in this post here:

https://powerusers.microsoft.com/t5/Building-Power-Apps/change-the-number-of-decimals-for-a-number/m-p/674626

I notice that you are using the English syntax in your formula (eg, where you separate the arguments in the Text function with a comma symbol). I guess your desktop machine is set up to use the English locale.

If the settings of your mobile device are set up to use a different language (I imagine Dutch), this can be a contributing factor because the default decimal separator would be comma symbol, rather than a period symbol. This would explain the difference between the desktop and the mobile device.

I would try to use the Round technique to begin with, because that would remove the dependency on formatting the value in a local specific way.

[Anonymous]

The problem is also present on my desktop version after doing this, while it isn't present when using Abs(). 

[Anonymous]

The round function also doesn't remove the issue. Do you perhaps know of any workaround to make powerapp recognize a comma symbol as a decimal seperator ? 

[Anonymous · Accepted solution]

Changing my phone language to English did the job! Thank you for the insight.

[Pstork1]

Using ',' instead of '.' as a decimal separator is dependent on the locale settings for SharePoint, Power Automate, and your phone.  If you are defaulting to English it won't use ',' as a decimal separator.  Your locale needs to be set for somewhere that uses ',' as a separator.

[SanjoyTrivedi]

Please use Int(ThisItem.'yourfieldname') in Text Function.

[PowerSA]

Thanks @Pstork1. I'm danish and my Edge language settings was set to danish, so when I changed to english the trailling zeros dissapeared. How to handle this if I want to share my app with other companies? I can't control the mix of languages for Sharepoint, Power Automate and peoples browsers. It will be a constant headache. Can you advice me on this?

[Pstork1]

Please post this as a new question.  You'll get more responses and others will be able to find the answer more easily later.