Power Platform Community Forum Thread Details

Hello,

We've encountered an issue with several end users now on iPhone where the user is unable to enter a decimal point in a text input control which only accepts numbers. When the user's device language is set to Spanish, but their number format setting is set to "1,234,567.89", all numbers in the Canvas app still use the "1.234.567,89" format. With these settings, the virtual keyboard only has a "." available, but the text input will not accept the "." and will only accept a "," for the decimal point character. Is there any workaround for this other than forcing the user to change their global device settings? Most of our users are using their personal devices so I really don't want to force them to change this setting just for work.

Thank you,

Categories:

Building Power Apps

assuming the text input just needs to be formatted in a certain way during the patch section of your app can instead of sending say, TextInput1.Text send

With({finalValue: 
 With({justTheDigits: Split(Substitute(Substitute(TextInput1.Text, ".",""), ",", ""),"")},
 With({
 fullSets: Sum(CountRows(justTheDigits)-2-Mod(CountRows(justTheDigits)-2,3))/3,
 leftOver: Mod(CountRows(justTheDigits)-2,3)
 },
 Concatenate(
 Concat(FirstN(justTheDigits,leftOver), Value),".",
 Concat(ForAll(Sequence(fullSets) As fullPasses, Concat(LastN(FirstN(justTheDigits, leftOver+Sum(fullPasses.Value*3)),3),Value)), Value, "."),",", Concat(LastN(justTheDigits,2),Value)
 
 )))}, If(Left(finalValue,1)=".", Right(finalValue, Len(finalValue)-1), finalValue))

this should adjust no matter how long the number is, and send it in, in ###.###.###,## format regardless if its typed in ###,###.## or ###.###,##