Announcements
Hello,
Can anyone help me with the formula to validate a Canadian Social Insurance Number? Validation would be done for a text field.
Thanks.
@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!
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:
Replying just to ask if you've found a solution for this?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 525 Most Valuable Professional
Haque 273
Kalathiya 232 Super User 2026 Season 1