How to force user to enter the digits at the end of a string only

(0) Share

Report

Posted on by garga

Hi All,

I have a requirement where i need to force user to enter the digits(if required) at the end of the string only.

e.g.

Test - Allowed

Test12 - Allowed

Test.Test - Allowed

Test.Test12 - Allowed

Test12.Test - Not Allowed

Test.12Test - Not Allowed

12Test - Not Allowed

Te12st - Not Allowed

Is there a way i can achieve this validation?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

MVP-Phipps 3,514 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

The only way I can think of doing this is by using the Match or IsMatch function within an if statement. Please refer to this documentation: https://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/functions/function-ismatch

Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.

LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/
Subscribe to my YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg

Was this reply helpful? Yes No
Verified answer

Ashwin7104 671 on at

Like (1)

Report
Copy link

Link copied!
Hey @garga ,

The below code is not the prettiest one but it works ! Please replace TextInput5 with your control

If( !IsNumeric(TextInput5.Text), If( IsNumeric( Right( TextInput5.Text, 1 ) ), "ok", IsMatch( TextInput5.Text, "[a-zA-Z._^%$#!~@,-]+" ), "ok", "Not ok" ) )

If this post helped you, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
MVP-Phipps 3,514 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Ashwin7104 IsMatch function with Regex, I was spot on then 👊

@garga you then use Notify function for OK or not ok

Was this reply helpful? Yes No
garga 8 on at

Like (0)

Report
Copy link

Link copied!

It worked for some cases but failed when i entered this text:

Te12st34

Was this reply helpful? Yes No
garga 8 on at

Like (1)

Report
Copy link

Link copied!

Thanks for the reply. I had to create regex for my specific case and i got it working.
IsMatch(TextInput1.Text,"([a-z]+)+(\d+)?$")

Was this reply helpful? Yes No