Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 6hpybseBlI33jAX9DJ4udF
Power Apps - Building Power Apps
Answered

Currency format

Like (2) ShareShare
ReportReport
Posted on 21 Feb 2018 10:47:08 by

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:
  • joviedo Profile Picture
    16 on 13 Mar 2024 at 22:41:20
    Re: Currency format

    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:

     

    joviedo_0-1710369668990.png

    Please help

     

  • Community Power Platform Member Profile Picture
    on 17 May 2021 at 21:11:56
    Re: Currency format

    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)

  • MihirY Profile Picture
    129 on 24 Jul 2019 at 11:56:58
    Re: Currency format

    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?

  • Verified answer
    JRaasumaa Profile Picture
    1,325 on 21 Feb 2018 at 12:37:29
    Re: Currency format

    @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!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 223 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 110

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 89 Super User 2025 Season 1

Overall leaderboard
Loading started