cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Phineas
Helper III
Helper III

How to Format Field for Currency

I've got a Label in a Gallery.

 

I need the data in the Gallery to display as 'Currrency', and not just a decimal deliniated number.

 

The data is formatted as currency in SP, but doesn't translate as such in the Power Apps Label.

 

How can I ge the following to do what I need? All three fields in the image should be displayed as 'Currency'.

 

Phineas_0-1614632356707.png

 

1 ACCEPTED SOLUTION

Accepted Solutions

Edit - Found my answer .....Text(ThisItem.FieldName, "#,##0")

How do I write it in the third field in the image so that it knocks all decimals off the number and adds a thousands comma and hundreds of thousands comma?

 

     From: 1234567.1234567

 

     To: 1,234

View solution in original post

3 REPLIES 3
RandyHayes
Super User III
Super User III

@Phineas 

I am not sure where CONCIDNoFld_185 fits into your formula, but your formula should be:

   Text(ThisItem.UnitCostPerSquareFoot, "$#,##0.00")

 

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

Edit - Found my answer .....Text(ThisItem.FieldName, "#,##0")

How do I write it in the third field in the image so that it knocks all decimals off the number and adds a thousands comma and hundreds of thousands comma?

 

     From: 1234567.1234567

 

     To: 1,234

View solution in original post

RandyHayes
Super User III
Super User III

@Phineas 

I am not sure what your logic is for going from 1234567.1234567 to 1,234.   Seems to me there must be some division math there to get to 1234.

 

However, based on what I perceive is your question, then the following will get you there.

   Text(Round(ThisItem.yourColumn, 0), "#,##0")

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Top Kudoed Authors
Users online (49,003)