Hi I have an issue with an expense application I have built. Not with the function of the app but with how the app is presented on European mobile phones.
Here is the specific issue. I have a plan input field, formatted to take in numbers in my case the amount of the expense purchase itself.
No currency is applied at input as that is handled behind the scenes in my SharePoint List. So the input is simply a raw floating point number ##.##
Required is both a dollar amount and a cents amount, even if the cents are zero.
The issue I have is when this field is displayed on specific European phones and the user clicks on the input field. The popup keyboard data can be entered from, does not contain the point/dot character, this is because currency in Europe uses the comma character for currency separation between dollars and cents. And when the user currently attempts to put a comma in this input, PowerApps rejects the entry as a non number.
So my question is can I force the input field to accept either the dot character or the comma character as valid input. Then regardless of which the user enters, always place the dot character in the data, so that all behind the scenes calculations work as normal?
I really do not want to create a extra text box for this one input and have to move data to a number formatted field on the form, if I can simply handle this issue in a formatting command from the input itself.
All guidance and suggestions welcome.
Kind regards
Duncan
