display calculated value on powerapps.

[Ben-00-38]

hello I have a format problem between the list and powerapps.
the value is a calculated value in the list: ok
problem display in powerapps adds bcp of 0.
list = 2632.50
powerapps 2632.50000

how to display the correct value 2632.50 in powerapps.

the problem is only on calculated values ​​of sharepoint lists.

[gabibalaban]

Hi @Ben-00-38 ,

Try this approach:

Text(YourColumnValue,"#.##")

Hope it helps !

[timl]

@Ben-00-38 

There is an issue in Power Apps where calculated columns don't format correctly. 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...

This formula should return the value to 2 decimal places:

Round(
      Value(ThisItem.PA),
      2
)

The French equivalent of the formula looks like this:

Round(
      Value(ThisItem.PA);
      2
)

[Ben-00-38]

with

Text (ThisItem.PVU; "#. ##")

no change

[timl]

Hi @Ben-00-38 

Did you try my suggestion?

Round(
      Value(ThisItem.PVU);
      2
)

[Ben-00-38]

Round (
Value (ThisItem.PA);
2
)
I read the link but it displays 0

[Ben-00-38]

yes i try and display = 0

[Ben-00-38]

[RandyHayes]

@Ben-00-38 

Use simply Value(ThisItem.PA) if that returns 0, then place your cursor after the PA in the formula and see what type of data PowerApps is thinking your column is...Number or Text?  It should be showing as Text (which is part of the long known issue).

I hope this is helpful for you.

[timl · Accepted solution]

Hi @RandyHayes 

I think the cause of this problem is that the SharePoint connector is returning text values in English format, which is evidenced by the values "2632.5000" and "4110.0000" in the earlier screenshots.

In this case, the value function expects inputs in French locale (eg "2632,5000" and "4110,0000"), and this is the reason why the conversion fails and returns 0.

I'm quite certain this would solve the problem

Round(
      Value(
           Substitute(
		ThisItem.PVU; "."; ",")
	);
      2
)

However, I'm a bit loathe to suggest it because I would prefer not to hardcode a dependency on the SharePoint input being in English format. Is there an alternative you could suggest here?