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

Refresh Dynamics 365 CRM Subgrid from Embedded Canvas App

In Microsoft Dynamics 365, the ability to embed Canvas Apps brings the power of Canvas Apps to their model-driven forms. Recently,...

More Articles Like This

- Advertisement -spot_img