web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Canadian SIN Validation

Power Apps

Unanswered

Canadian SIN Validation

(0) Share

Report

Report

Posted on by PowerSuiteUser

Hello,

Can anyone help me with the formula to validate a Canadian Social Insurance Number? Validation would be done for a text field.

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Gochix 1,935 Moderator on at

Like (0)

Report

@PowerSuiteUser ,

Could you give us some context on how you wish to validate this Social Insurance Number?
Do you have a database/SharePoint List/OneDrive etc. ?

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

Was this reply helpful? Yes No
a33ik 3,306 Most Valuable Professional on at

Like (0)

Report
Hello,

I used the following formula to validate it:

If( IsMatch( TextInput1.Text, "^(?!000|9\d{2})\d{3}-(?!00)\d{3}-(?!0000)\d{4}$" ), "SSN Is Valid", "SSN Is Not Valid" )

The result was bound to the label underneath the text input:

Was this reply helpful? Yes No
EHelf1 2 on at

Like (0)

Report

Replying just to ask if you've found a solution for this?

Was this reply helpful? Yes No

Join the conversation