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
Solved! Go to Solution.
You will want to use IsMatch https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-ismatch
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"),
)
You will want to use IsMatch https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-ismatch
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"),
)
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
Indeed. Will try using different combinations with this. Thanks.!!!
User | Count |
---|---|
196 | |
124 | |
87 | |
49 | |
42 |
User | Count |
---|---|
284 | |
163 | |
138 | |
75 | |
72 |