cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MichaelDee
Frequent Visitor

Number format - formular correct but displays incorrect

Hello, 

Can someone please help me with this?
I believe I have the right formular to show the value as "35.000" (in Denmark the punctuation is 1000-separator).

It does show the right value under the formular på not on the card.

 

MichaelDee_1-1646302646297.png

 

Thanks!

Michael

 

8 REPLIES 8

Check these examples:

 

Text(Value(35.000,"pt-BR"),"##.000")
Text(Value(35.123,"pt-BR"),"##.000")

mar22_35123.gif

 

 

 

 

See if this works better for you.

 

Also see documentation on Text function for more info.

@poweractivate Thanks, however, I still don't see the right format on the canvas:

MichaelDee_0-1646309292520.png

I pull the data from a MS List, where the field is defined as number.

Hi @MichaelDee,

Try as below:

Text(Value(Parent.Default);"[$-pt-BR]#.###,##")
Best Regards,
Qi

@v-qiaqi-msft Thanks, however, i still don't see the right format on the card.

MichaelDee_0-1646391876944.png

BR

MichaelDee

Hi @MichaelDee,

Could you please check the format property of the Text Input?

Make sure that the Format is Number type.

vqiaqimsft_0-1646622095010.png

 

Best Regards,
Qi

Hi @v-qiaqi-msft 

The Format is blank. When I mouse over I see that it is formatted by the formular (Text(Value(Parent.Default);"[$-pt-BR]#.###,##").

In the Microsoft list (where this field is pulled from) it is defined as a number.

 

Thanks!

Michael

Hi @MichaelDee,

Could you please format it as Number and check if it works?

Best Regards,
Qi

Hi @v-qiaqi-msft Thank you for your effort to solve this. However, you're suggestion on formatting as a number is where I came from. The standard number format doesn't provide any additional formatting, I will see the number as "35000" instead of "35.000" (in Denmark or US "35,000").

MichaelDee_0-1646984963267.png

Thanks Michael

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (4,116)