Power Community

Power Community

Data Validation PowerFx Code Using Regex Expression!

If(                                        //Conditional Statement
    CountIf(                              //If Statement
        Split(                           //Split each string into substrings
            AddressTxt.Value,            //TextInputControl
            ""                          //Splitting value
        Not(                            //Condition Expression
            IsMatch(                    //Match Function
                Value,                  //Condition Value
                "([A-Za-z0-9])"         //RegexExpression 
    ) > 0,                              //Condition
    "Wrong Character in-text"           //DisplayText

This post was originally published on this site

- Advertisement -spot_img


Please enter your comment!
Please enter your name here

- Advertisement - Advertisement

Latest News

Capture and visualize ideas without spatial constraints using Infinite Canvas in Visio for the web

Following our announcement earlier this year about mind maps in Visio for the web, we’re excited to announce a...

More Articles Like This

- Advertisement -spot_img