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 Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

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 (3,529)