Unanswered

Currency format

(2) Share

Report

Posted on by Community Power Pla...

In my app result is showing as €13,321,857,600 and €2,921,824,072 but I want result as €133,218,576.00 and €29,218,240.72

Function used in-app is "€"&Text(ThisItem.QuoteValue,"[$-en-US]###,##")

any help here would be really appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

JRaasumaa 1,325 on at

Like (1)

Report

@Anonymouswrote:
In my app result is showing as €13,321,857,600 and €2,921,824,072 but I want result as €133,218,576.00 and €29,218,240.72

Function used in-app is "€"&Text(ThisItem.QuoteValue,"[$-en-US]###,##")

any help here would be really appreciated.

You will need to change the formatting to include the comma, decimal point and trailing zero to include them all.

"€"&Text(ThisItem.QuoteValue,"[$-en-US]###,###.00")

So if your value being converted is equal to:
29218240.72 The conversion looks like €29,218,240.72
and
133218576.00 converts to €133,218,576.00

You can also just include the euro in front of the text formatting without having to add it to the front with &.

Text(ThisItem.QuoteValue,"[$-en-US]€###,###.00"

Let me know how this works out for you!

Was this reply helpful? Yes No
MihirY 129 on at

Like (1)

Report
But I am having some issue with second implementation that you have mentioned. I have written for currency format as below
Text(Sum(varCostCapital, varCrntCostCapital, varEditedPrevCap),"[$-en-US]$ ###,##0.00")
This is working fine when US people open the PowerApp form as $ 9500.00. But when Taiwan people are opening this form, currency value is showing as NT$ 9500.00

So I think appending $ infornt of the formula will be good rather than this approach. What is your thought on this?

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

Like (0)

Report

I also made negative numbers red, but updating the color property on the advanced tab
If(Value(ThisItem.Field)>0,RGBA(0, 0, 0, 1),Red)

Was this reply helpful? Yes No
joviedo 16 on at

Like (0)

Report

Im from Colombia. I'm havig the same problem in a Form DataCardValue. In the default property of the datacard i use Text(Parent.Default;"[$-en-US]$ #,###"), what i have is € 17,500 and appending it makes it desappear like this:

Please help

Was this reply helpful? Yes No