cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ThomasVDS
Helper III
Helper III

Thousand seperator is always showing

Hi,

 

I am trying the build a formula to show a numeric field formatted with thousand and decimal seperator.

When I use the formula below, the thousand seperator is always shown, also for numbers below 1000.

How can I solve this? Do I need to add a If condition?

 

Text(Value(Parent.Default),"[$-fr-FR]#.###,00 €", "fr-FR")

Result: .370,00 € -> NOK

 

Kr

1 ACCEPTED SOLUTION

Accepted Solutions
v-siky-msft
Community Support
Community Support

Hi @ThomasVDS ,

 

I have made a test with the following three formulas which should work, but find somthing weird. 

Text(1501,"[$-fr-FR]#.#,00", "fr-FR")    /* show 150.1,00 */
Text(1501,"[$-de-DE]#.#,00", "de-DE")   /* show 1.501,00 */
Text(1501,"[$-en-US]#,#.00","en-US")   /*show 1,501.00 */

PowerApps should automatically recognize and delimit the thousands seperator, so we just need to use the format of "#.#,00", and the value of 1501 will show as 1.501,00. if the value , such as 501, is smaller than 1000, it will show as 501.00.

However this format only doesn't work for French language, it can work well for German or English(Even if the seperators are different).  it is really weird! I would post this to Microsoft PowerApps Team if my doubt is confirmed.

For the time being, to French language, it seems that only If function can help to determine whether a thousandth seperator is needed.

Please refer the following formulas:

If(Value(Parent.Default)>1000,Text(Value(Parent.Default),"[$-fr-FR]#.###,00", "fr-FR"),Text(Value(Parent.Default),"[$-fr-FR]###,00", "fr-FR"))

Hope this helps.

Best regards,

Sik

 

View solution in original post

2 REPLIES 2
v-siky-msft
Community Support
Community Support

Hi @ThomasVDS ,

 

I have made a test with the following three formulas which should work, but find somthing weird. 

Text(1501,"[$-fr-FR]#.#,00", "fr-FR")    /* show 150.1,00 */
Text(1501,"[$-de-DE]#.#,00", "de-DE")   /* show 1.501,00 */
Text(1501,"[$-en-US]#,#.00","en-US")   /*show 1,501.00 */

PowerApps should automatically recognize and delimit the thousands seperator, so we just need to use the format of "#.#,00", and the value of 1501 will show as 1.501,00. if the value , such as 501, is smaller than 1000, it will show as 501.00.

However this format only doesn't work for French language, it can work well for German or English(Even if the seperators are different).  it is really weird! I would post this to Microsoft PowerApps Team if my doubt is confirmed.

For the time being, to French language, it seems that only If function can help to determine whether a thousandth seperator is needed.

Please refer the following formulas:

If(Value(Parent.Default)>1000,Text(Value(Parent.Default),"[$-fr-FR]#.###,00", "fr-FR"),Text(Value(Parent.Default),"[$-fr-FR]###,00", "fr-FR"))

Hope this helps.

Best regards,

Sik

 

@v-siky-msftThanks for your analysis!

 

I modified my formula using the German language and now it works fine 🙂

 

Kr

Helpful resources

Announcements
Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Government Carousel

New forum: GCC, GCCH, DoD - Federal App Makers (FAM)

In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.

Users online (2,251)