web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps european formatting in...

Power Apps

Unanswered

european formatting in general

(0) Share

Report

Report

Posted on by jlke-as

130

Hi

I need help to change power apps to work with european formatting of numbers.

In this case I have formatted the red circle to show 2 digits (seperated by ",")

In the green circle the user may enter a number with 2 digits (seperated by ",")

In the purple circle the system calculates the sum of the figures in the gallery with 2 digits (seperated by ",")

In the gallery the blue circle should show 2 digits (seperated by ",")... But it doesn't work... See the formular...

How do I get the figures in the gallery to be shown with digits seperated by ",".... My formular doesn't work...

How do I get all the figures to be shown with 2 digits (",00" if there is no digits in the number)?

Skærmbillede 2023-07-07 143842.png

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

madlad 2,637 Moderator on at

Like (0)

Report
When you format your numbers, try replacing the trailing "##" with "00". Adding the 00 on the end should make it so 00 is there if there's no other decimal values.

As for formatting numbers to use "," when formatting text, I'm not 100% confident, since it seems like we probably have different language settings. However, if you find that your numerical values are returning formatted as "##.##" and you want "##,00", you could try something like:

Substitute(Text(*YourNumber*, "##.00"),".",",")

Hope this helps!

Was this reply helpful? Yes No
jlke-as 130 on at

Like (0)

Report

Hi
I doesn't work... If you substitute-formular in the gallery it converts the "3.5" to "3,5" - but it still calculates that "10" + "3,5" equals "45"...
So I still need fixed 2 digits and the right calculation...

Was this reply helpful? Yes No

Join the conversation