cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JohnRavas
Frequent Visitor

How do I format a field to look like currency

I have a form that is connected to a SharePoint list.  One of the fields is a Currency field.  However, the form will not allow me to display the field as currency.  The only choices I seem to have are text or number.  When in display mode, I would like it to be formated like $500.00.

 

Thanks in advance

1 ACCEPTED SOLUTION

Accepted Solutions

I enriched this solution such that it displays the currency field numeric value format as a Number in Edit mode for the Form, and then using the same Input Box control it displays the field as a currency value when the form is in View mode. This seemingly negates the need to have multiple controls on the form (hidden or visible) which naturally then makes the form easier to edit and manage as addional fields are added and/or the form functionality in enhanced!

 

Displaying numeric fields as Currency in PowerApps

View solution in original post

8 REPLIES 8
CarlosFigueira
Power Apps
Power Apps

You can update the Text property of the label that is used to display the value, and use a custom expression that displays the format as you want. Below is one way how you can do that.

CustomizeCurrencyField.gif

Thanks for the reply @CarlosFigueira  What you show makes sense.  However, when I go into the advanced properties for my field , I don't have a Text property like you do - see my screenshot.  Under the Properties tab, my Format is set to number as I don't want people entering text in the field.  Hopefully I am missing something simple.

Ah, you're using an Edit form, in View mode. For that case (which uses a text input control) there's no way to directly set the format of the data that is going to be displayed.

 

One thing you can do is to have two controls, the text input that comes with the card, and add another label on top of it. Depending on the mode of the form, you can toggle the Visible property of the controls, like in the set of properties below:

DataCardValueX.Visible: EditForm1.Mode <> FormMode.View
NewLabelInCard.Visible: EditForm1.Mode = FormMode.View
NewLabelInCard.X: DataCardValueX.X
NewLabelInCard.Y: DataCardValueX.Y
NewLabelInCard.Height: DataCardValueX.Height
NewLabelInCard.Width: DataCardValueX.Width
NewLabelInCard.Text: Text(Parent.Default, "[$-en-US]$0.00")
v-xida-msft
Community Support
Community Support

Hi @JohnRavas,

 

Could you please share a bit more about your app's configuration?

Do you want the field within your Display form or Edit Form to be formatted like currency?

 

I have made a test on my side, please take a try with the following steps:

  • Unlock the DataCard where you want to format the field to currency.
  • Within the DataCard, select the TextInput control.
  • Within right panel, set Default property to following formula:
Text(Parent.Default,"[$-en-US]$#,###.00")

or 

Text(Parent.Default,"[$-en-US]$#.00")

Image reference:1.JPG

 

More details about the Text function in PowerApps, please check the following article:

Text function

 

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I enriched this solution such that it displays the currency field numeric value format as a Number in Edit mode for the Form, and then using the same Input Box control it displays the field as a currency value when the form is in View mode. This seemingly negates the need to have multiple controls on the form (hidden or visible) which naturally then makes the form easier to edit and manage as addional fields are added and/or the form functionality in enhanced!

 

Displaying numeric fields as Currency in PowerApps

Anonymous
Not applicable

How can I use the same format for euro?

I tried "€ " & Text(Parent.Default,"€#,###.00") but it turns like this "€ " & Text(Parent.Default,"[$-en-US]€#,###.00"), and the result is

€ 30000 not € 30 000 as I want.

 

Kaminski_Henr
New Member

Hello,

 

Try this, was the only way that worked for me:

 

Text(Value(Parent.Default;"pt-BR");"#,###")

You need to use a semicolon instead of a comma in the formula. Try this:

 

Text(Parent.Default; "€#,###.00")

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (5,331)