Answered

Format TextInput to accept number only with "."

(0) Share

Report

Posted on by IonutHzd

Hello,

I am building a power app where the users have to enter the time they worked on a project and store it in a SharePoint list. They can enter integers or float numbers.

My issue is that some users must use commas and some use dots ( 1,5 or 1.5 ) and I have been asked to make it so everyone uses the same format but when I force the usage of the dot then the users that needed comma get their hours as integers when patching ( 1,5 becomes 15 ).

Is it even possible to achieve this or is it tied to the local settings of each user?

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

VishalJhaveri 1,169 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Now, to achieve this requirement, Convert the text input control such that it accepts only Number in its FORMAT property.
On doing this change, the user might be restricted to use the comma in text input control. Also it would be advisable to add a hint text in the text input control so that which facilitates the user to know the exact format of the number.
Text input control in Power Apps - Power Apps | Microsoft Learn

Now, I guess this should definitely work and fulfill your requirement.
Thank you.
If my answer helps you, please mark it as solution.
iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

This won't solve the issue. The number format uses the local number format for the user, and won't be consistent.

@IonutHzd give me a few minutes and I'll have a proof of concept for you that strips out other characters from a text-format text input
Verified answer

iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!
Ok, so you'll need a timer, a label to display the error message (for when they use more than one . (period) - then you can get it to strip out all characters except those that are valid.

TextInput.Default:

gblOriginalTextValue

Timer.OnTimerStart:

Set(gblOriginalTextValue, Concat(Split(TextInput1.Text, ""), Value)); Set( gblOriginalTextValue, With({SplitList: Split(TextInput1.Text & ".", "")}, Coalesce( Concat( ForAll(Sequence(CountRows(SplitList)), If( Value = CountRows(SplitList) && Last(FirstN(SplitList, Value)).Value=".", "", If(IsMatch(Last(FirstN(SplitList, Value)).Value, "[0-9.]"), Last(FirstN(SplitList, Value)).Value, "") ) ) , Value ) ) ) ); If(CountRows(RemoveIf(Split(gblOriginalTextValue, ""), !IsMatch(Value, "[.]")))>1, Set(ErrorMessageText, "This is not a valid number, please use a period as your decimal separator, only one period is required"), Set(ErrorMessageText, ""))

ErrorMessageLabel.Text:

ErrorMessageText

Here's it in action:

And at the bottom here you'll find a proof of concept app attached 🙂

Cheers,

Sancho

Remove invalid ch...
IonutHzd 87 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you very much for the suggestion and the demo!
It didn't fix my problem as the users that needed to use comma still get their number patched as integers but this will be very useful in different projects.
iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Did you make the Text Input format Text rather than number? Keeping it as number will still probably end up with it getting used as a locally-formatted number.

Also, does your Update property of the datacard use the Value() function to store in the datasource as a number, as that will also convert it to a local format number - best to use a text column in the datasource and force the validation in the App (removing the Value reference and just storing the output as the cleaned-up text from my previous example)