web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps If TextInput contains ...

Power Apps

Unanswered

If TextInput contains 10 digits, Success, Error

(0) Share

Report

Report

Posted on by Masonf2265

74

HI Everyone,

I am trying to create a data validation formula for phone numbers. I want the Match function to count if there are 10 numbers and if so, no notification, if not, display an error message. I do not want any custom formatting like If(IsMatch( LeftParen & Digit & Digit & Digit &RightParen & Space& Digit & Digit & Digit & Hyphen & Digit & Digit & Digit & Digit), Success,Error).

I simply want to ensure people are typing 10 numbers. That's all. I have input masking overlayed so this is why i only need to verify that 10 numbers are inputted.

Any help is much appreciated!

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Masonf2265

Consider the following:

If(CountRows(Filter(Split(yourPhoneNumberValue, ""), IsNumeric(Result)))=10, Success, Error)

So, if you had a label to display if there is not a valid phone number, set the Visible property to:

!(CountRows(Filter(Split(yourPhoneNumberValue, ""), IsNumeric(Result)))=10)

I hope this is helpful for you.
Pstork1 69,661 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
If you want them to just type the numbers then use the following isMatch

IsMatch(TextInput2.Text,"[0-9]{10}")

Join the conversation