Display quantities with two decimals in columns formulated in sharepoint

[Rob_G]

Hi,

I have columns with calculated field in sharepoint. For example: (subtract two columns from the same list).
This field calculated in sharepoint I can look at it with two decimal places, but when I look at it in powerapps, it appears with many decimal numbers. How can I make it look like two decialmes or without any decimal number.

Attached screens

[mdevaney · Accepted solution]

@Rob_G 

Can you please try this code in the Text property of the label?

Text(Value(ThisItem.Retraso),"0.00")

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[Rob_G]

Hi,
I send a video with the result,
I still have the problem,

https://drive.google.com/file/d/1OrBo49LJRim0SdwH3RXR7NOQ6oLBfJdj/view?usp=sharing  

Regards,

[mdevaney]

@Rob_G 

I don't download files from people I do not know.  You'll have to show it another way.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[Rob_G]

I will explain here, sending some images, but before I want to mention the following.
I am observing that in PowerApps this calculated column which has Sharrepoint as its data source, shows the field as text and not as number in Power Apps.

With the option for the solution that they indicated, we have:

Instead of removing all the zero numbers that it has to the right of each number, it adds two decimal places and then when I click elsewhere the formula automatically changes.

[Rob_G]

I will explain here, sending some images, but before I want to mention the following.
I am observing that in PowerApps this calculated column which has Sharrepoint as its data source, shows the field as text and not as number in Power Apps.

With the option for the solution that they indicated, we have:
Instead of removing all the zero numbers that it has to the right of each number, it adds two decimal places and then when I click elsewhere the formula automatically changes.

Regards

[Rob_G · Accepted solution]

Hello everyone, I reviewed the sharepoint and I had to change the regional configuration of the site.
Now it works.

Thank you.