Answered

How do I format a field to look like currency

(5) Share

Report

Posted on by JohnRavas

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

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

CarlosFigueira on at

Like (37)

Report

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.

Was this reply helpful? Yes No
JohnRavas 25 on at

Like (0)

Report

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.

Currency No Text ...

Was this reply helpful? Yes No
CarlosFigueira on at

Like (0)

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

Was this reply helpful? Yes No
v-xida-msft on at

Like (10)

Report
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:

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

Text function

Best regards,

Kris

Was this reply helpful? Yes No
Verified answer

Office365Master 338 on at

Like (7)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (2)

Report

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.

Was this reply helpful? Yes No
Kaminski_Henr 4 on at

Like (0)

Report

Hello,

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

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

Was this reply helpful? Yes No
RobStand Microsoft Employee on at

Like (1)

Report

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

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

Was this reply helpful? Yes No
CG-25072327-0 9 on at

Like (3)

Report
I used the suggested solution:
"$" & Text(Parent.Default, "0.00")
But larger numbers would display as $100000.00 -- I wanted the comma separator for thousands, so I am using:
"$" & Text(Parent.Default, "#,##0.00")
This adds a thousands separator AND null values will appear as $0.00 rather than $.00. I wouldn't have figured this out without your original post. Thanks.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

If the number is '123456', how to display it '1,23,456'?

Was this reply helpful? Yes No