How to Format Field for Currency

[Phineas]

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'.

[RandyHayes]

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

[Phineas · Accepted solution]

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

[RandyHayes]

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