cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
russrimm
Level: Powered On

Decimal places and Currency

Hi all,

I am struggling to get two decimal places to show in my datatable.  I stuck a label in over to the right that has Text(Sum(expense,Estimated),"[$-en-US]#,##0.00") and notice that it shows $12.50 which is how I want it to display.  However, in the datatable under "Estimated Expense", it shows $12.5 instead of $12.50.  I tried setting the Items value of the datatable to AddColumns(expense,"calcfield",Text(EstimatedDatacard.Text,"[$-en-US]#,##0.00")) but I must have it wrong as the added column is completely empty. 

"EstimatedDatacard" is the inputbox under "Estimated Expense" which is set to a "Number" format.

Decimal.PNG

Any ideas?

1 ACCEPTED SOLUTION

Accepted Solutions
Dual Super User
Dual Super User

Re: Decimal places and Currency

Right now there is no way to apply formatting directly to a data table column.  But you can use AddColumns to add pre-formatted fields to the datasource or collection you are passing to a data table.  Here's a Blog that shows how to do it.

https://blogs.msdn.microsoft.com/carlosfigueira/2017/09/01/formatting-fields-in-data-tables/



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

1 REPLY 1
Dual Super User
Dual Super User

Re: Decimal places and Currency

Right now there is no way to apply formatting directly to a data table column.  But you can use AddColumns to add pre-formatted fields to the datasource or collection you are passing to a data table.  Here's a Blog that shows how to do it.

https://blogs.msdn.microsoft.com/carlosfigueira/2017/09/01/formatting-fields-in-data-tables/



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 316 members 5,697 guests
Please welcome our newest community members: