cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rob_G
Helper I
Helper I

Display quantities with two decimals in columns formulated in sharepoint

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 screensNumbers Decimals 02.jpg

2 ACCEPTED SOLUTIONS

Accepted Solutions
mdevaney
Super User III
Super User III

@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."

View solution in original post

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

Thank you.Numbers Decimals 08.JPG

View solution in original post

6 REPLIES 6
mdevaney
Super User III
Super User III

@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."

View solution in original post

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

 

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

 

Regards,

@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."

 

 

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.

Numbers Decimals 03.JPG

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.

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.

Numbers Decimals 03.JPG

Numbers Decimals 04.JPG

 

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.

 

Numbers Decimals 07.JPGNumbers Decimals 06.jpg

Regards

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

Thank you.Numbers Decimals 08.JPG

View solution in original post

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power Apps User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (25,874)