cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AkshayManke
Continued Contributor
Continued Contributor

Enforcing Values with Combination of Specific Charaters and Numbers

Hello,

 

I am working on a solution where user should enter his/her PAN Number. (PAN is Permanent Account Number issued by Income Tax Department in India). The PAN is consisting of 10 digit alphanumeric number out of which first 5 are characters then 4 numbers and then again 1 character (Example: ABCDE1234Z). 

 

I want to have a validation/restriction that, the user must enter the PAN in the given format only - first 5 are characters then 4 numbers and then again 1 character. If any other combination (ABCDEFG123 or 1111111111) he/she enters then it should not allow to be submitted. 

 

How can we achieve this?

 

Regards,

Akshay

2 ACCEPTED SOLUTIONS

Accepted Solutions
timl
Super User
Super User

Hi Akshay

As @jlindstrom correctly says, IsMatch is the way to do this.

The following expression will return true for a matching PAN number.

IsMatch("ABCDE1234Z", 
        "[A-Z]{5}[0-9]{4}[A-Z]{1}"
)

If you're using a form, you can add the following to your submit button.

 

If(IsMatch(txtPanNumber.Text, 
        "[A-Z]{5}[0-9]{4}[A-Z]{1}"
        ),
   SubmitForm(FormName),
   Notify("Invalid PAN Number"),
)

 

 

 

View solution in original post

5 REPLIES 5
timl
Super User
Super User

Hi Akshay

As @jlindstrom correctly says, IsMatch is the way to do this.

The following expression will return true for a matching PAN number.

IsMatch("ABCDE1234Z", 
        "[A-Z]{5}[0-9]{4}[A-Z]{1}"
)

If you're using a form, you can add the following to your submit button.

 

If(IsMatch(txtPanNumber.Text, 
        "[A-Z]{5}[0-9]{4}[A-Z]{1}"
        ),
   SubmitForm(FormName),
   Notify("Invalid PAN Number"),
)

 

 

 

View solution in original post

AkshayManke
Continued Contributor
Continued Contributor

Hi @timl@jlindstrom ,

I tried the suggested solutions by both of you (using IsMatch) and it is working exactly as expected. Many thanks for your help on the same. Accepting both's reply as solutions. 😊

Regards,,

glad it worked for you. There’s a lot of cool

stuff you can do with that

AkshayManke
Continued Contributor
Continued Contributor

Indeed. Will try using different combinations with this. Thanks.!!!

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,969)