Unanswered

Regular Expression for Textbox

(0) Share

Report

Posted on by Vakula

Hi,

I have a textbox which should take "*" as default value. Also, it should accept only numeric values up to 1 decimal point and value should not be greater than 100, since it is percentage.

Example: Accepted values in Textbox : *, 23.1, 32.1, 100, etc..

Not Accepted : 23.22, 101, etc..

Please help me with regular expression or what is the best way to achieve this.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@vakula

Can you describe your scenario a bit more? Are you stating that you want the TextInput to validate as the user types something and only allow certain patterns? If so, then this is Input Masking that PowerApps does not currently support.

If you are trying to achieve some sort of visual notification (red border, a warning message, etc.) then this can be achieved and can be best done with a series of verifications including, but not limited to, a regular expression.

Was this reply helpful? Yes No
CU-18081211-6 9,270 Moderator on at

Like (0)

Report

Hi @vakula ,

Starting from the second assumption of @RandyHayes here is a proposal:

IsMatch(TextInput.Text,"\d\d.\d") || Value(TextInput.Text)=100 || TextInput.Text="*"

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@gabibalaban

Actually, that expression will not match the conditions properly. That formula would assume that all inputs have to have a decimal and digit.

It would go more like this:

With({val: TextInput.Text,}, IsMatch(val, "\d{2}(\.\d)?") || val="100" || val="*")

The above regex allows for two digits and an optional decimal and digit. Three digit numbers would only be 100 and is tested for outside of the regex.

Was this reply helpful? Yes No
Vakula 50 on at

Like (0)

Report

@RandyHayesShould this be written on Onchange Property of textbox?

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report

@vakula

No, it will do nothing there. As mentioned - "If you are trying to achieve some sort of visual notification (red border, a warning message, etc.) then this ..."

So, for example, this formula on the Fill property of the TextInput will give you visual indication of the error.

If(With({val: Self.Text,}, IsMatch(val, "\d{2}(\.\d)?") || val="100" || val="*"), Transparent, Red)

Was this reply helpful? Yes No
Vakula 50 on at

Like (1)

Report

@RandyHayes Thanks, It worked!!

Was this reply helpful? Yes No