
It sounds like you're facing a challenging issue with the input format for pH values in your Power Apps. Here are a few suggestions that might help resolve this problem:
Custom Validation: Implement custom validation logic to handle both comma and dot as decimal separators. You can use the OnChange property of the text input control to check the input and convert it accordingly.
Locale Settings: Adjust the locale settings of your app to ensure it correctly interprets the decimal separator based on the user's language settings. This can be done by setting the Language property of the app.
Regular Expressions: Use regular expressions to replace commas with dots or vice versa before processing the input. This can be done within the OnChange event of the text input control.
Separate Input Fields: Consider providing separate input fields for users based on their locale. For example, one field for users who use commas and another for those who use dots.
Custom Keyboard: If possible, create a custom keyboard layout that only allows the correct decimal separator based on the user's locale.
Here's a sample formula for custom validation using the OnChange property:
If(
IsMatch(TextInput.Text, "^\d+,\d+$"),
Set(TextInput.Text, Substitute(TextInput.Text, ",", ".")),
TextInput.Text
)
This formula checks if the input contains a comma and replaces it with a dot.
If the response is helpful to you, a like or mark as the correct solution. thank you so much!