Unanswered

Currency Format not working

(0) Share

Report

Posted on by southafrican

Hello,

I'm trying to get the selected data card to show the data in some sort of number form e.g. 123,456,789. I've put the code I believe would change the figures, but nothing seems to be happening.

Does anyone have any idea of what I can do?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Pstork1 68,707 Most Valuable Professional on at

Like (1)

Report

The formula you are using changes the value into a formatted Text string. But the field itself is set for Number. So although you are transforming it to a formatted text the field is then transforming it back to a number. I think your Text() formula is right, but it needs to be in a Text field, not a Number field.

Was this reply helpful? Yes No
iAm_ManCat 18,228 Most Valuable Professional on at

Like (1)

Report

Hi @southafrican

You're trying to use a Text value inside a number-formatted field, so it will revert whatever text changes you do to display it as a number again with the default number formatting

If you have decimals within that number, it will show decimals, but the default formatting is to hide decimals when there are none rather than to display .00 as you would probably expect:

Cheers,

ManCat

Was this reply helpful? Yes No
southafrican 31 on at

Like (0)

Report

@Pstork1 wrote:
The formula you are using changes the value into a formatted Text string. But the field itself is set for Number. So although you are transforming it to a formatted text the field is then transforming it back to a number. I think your Text() formula is right, but it needs to be in a Text field, not a Number field.
So I changed the format as you suggested and it doesn't seem to have done anything?

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

Since you are using a Card you are binding it to a field. But your formula is for the Default property. So I think the default is being set correctly and then overridden by the bound value.

Was this reply helpful? Yes No
Verified answer

v-xida-msft on at

Like (1)

Report
Hi @southafrican ,

Based on the formula you provided, I think there is something wrong with it. The second argument of the Text function is required to type a CustomFormat formula, but you typed a Currency.

Please consider modify your formula as below:

Set the Default property of the Budget (F19/20) Text Input box to following:

Text(displayItem.'Last Approved PLF Value (FY19/20)', "[$-en-US] ##,###")

or

Text(Value(displayItem.'Last Approved PLF Value (FY19/20)'), "[$-en-US] ##,###")

Please consider take a try with above solution, then check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
southafrican 31 on at

Like (0)

Report

Thank you, the change in the formula you provided worked.

Was this reply helpful? Yes No