Hello everyone,
I have a small problem with text inputs in my gallery.
My gallery takes data from an SQL table, one field having the data type "money". Now I want to make this value editable in the gallery so I decided to display it in a text input field. That has worked fine without any formatting, but now I want to format the displayed values in the input field (and later restrict the allowed entry format) to show as currency, not just a plain number.
After setting the default value of the wanted format, all fields showed as empty. I set the following, which worked fine for labels:
Text(ThisItem.MoneyField;"[$-de]###.###.##0,00")&"€"
Some testing revealed that the text input auto-clears whenever I enter something different than a number. So in the following examples, example 1 and 2 are fine but 3 is cleared (the comma being the decimal delimiter here):
- 10000
- 10000,00
- 10000€
- 10.000,00
Number 4 is slightly special in that I can remove [ &"€" ] from the above code, and it displays [10.000,00] correctly, but when I try to type it in manually, it removes the period instantly while typing (as it is not a digit or decimal delimiter, I suppose).
Is this behavior known and is there a way to properly display currency in a text input?
I appreciate any help or idea!
Edit: I can append the above code to another text input field as follows and it displays the formatted number properly
ThisItem.TextField & " " & Text(ThisItem.MoneyField;"[$-de]###.###.##0,00")&"€"
I would guess that Power Apps recognizes the first field referenced to be a number field somehow and restricts the permitted values but does not do so when the first field is text-based...
