Forum Discussion

Copper Contributor

Aug 04, 2022

Solved

Column validation formula for numbers and special character, no alpha characters

Hello. I'm trying to write a column validation formula for a column that should only accept numbers (0-9) and these special characters ("$", "%", ",", "."). Could someone please advise me on how I co...

microsoft lists

SharePoint Online

ganeshsanap
Aug 05, 2022
meredithhurston
Addition to kalpeshvaghela response, here's Microsoft official documentation for pattern matches (RegEx) in Power Apps: IsMatch, Match, and MatchAll functions in Power Apps

Documentation covers special characters, predefined patterns (Digit, Email, Space, etc.) and lot of example to understand it easily.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Eliot_Cole

Iron Contributor

Aug 06, 2025

Hey, meredithhurston ... I know this is 3 years later ... but you could possibly look to using the opposite of this formula (which I cribbed from this stack answer) ... perhaps by wrapping NOT() functions around the IF() statements?

=AND(
  IF(ISERROR(FIND("~",Title)),TRUE),
  AND(
    IF(ISERROR(FIND("@",Title)),TRUE),
    AND(
      IF(ISERROR(FIND("!",Title)),TRUE),
      AND(
        IF(ISERROR(FIND(",",Title)),TRUE),
        IF(ISERROR(FIND("&",Title)),TRUE)
      )
    )
  )
)

I can confirm that the linked positive affirmation has worked on my own tests, but I haven't found a way to make my suggestion, above, work. 😥🤔