You’re offline. This is a read only version of the page.
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
I have a Sharepoint list with a Powerapps form to input the data. There are about 50 separate Currency type fields in the Sharepoint list, but when these Data Cards are added as fields in the PowerApp form builder, the number formatting reverts to a decimal with about 20 decimal places.
A - is there really no way for the Powerapp to automatically use the number formatting defined in the list?
B - even if the above is not possible, is there not a way to set up the number formatting more efficiently than going through this manual process for every single data card?
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.
Hello,
Try this, was the only way that worked for me:
Text(Value(Parent.Default;"pt-BR");"#,###")
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.
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!
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:
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:
Best regards,
Kris
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")
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.
#1
WarrenBelz
146,518
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,756
Most Valuable Professional
Share
Report
All responses (
Answers (
