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
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (2,283)