Power Community

Power Community

Data Validation PowerFx Code Using Regex Expression!

image
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

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisement - Advertisement

Latest News

Enhance Competitor Analysis with Integrated Maps within Dynamics 365 CRM

“Keep your Friends Close but your Enemies Closer”- Sun Tzu In a business, it is not just about sincerity but...

More Articles Like This

- Advertisement -spot_img