email validation solution for Power Apps form that only accepts correctly formatted emails

[PowerStar321]

Hi All,

I am fairly new to Power App forms and I am looking for help with email validation. I am trying to create a Power App form with email validation, but I am having some issues when using the default code

If(

    IsMatch(

        DataCardValue3.Text,

       Email

    ),

    Check,

    Icon.Warning

)

When I use this default code above, users can still type in email addresses with invalid characters like spaces, £,$,%,^… as shown in the screenshots below.

• Not accepted because it doesn’t include @, and also includes spaces and invalid email characters.

• Accepted because it does include @, but still includes spaces and invalid email characters.

• Accepted because it does include @, but still includes spaces and invalid email characters.

I have tried using the Regular Expression recommended by Microsoft on their Power Apps page https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-ismatch

If(

    IsMatch(

       DataCardValue3.Text,

      ".+\@.+\\.[^\\.]{2,}"

    ),

    Check,

    Icon.Warning

)

But it also has random validation output as shown below

• Not accepted.

• Not accepted. Icon changes green instead of red.

• This should show a green tick because it is correct, but it shows a green warning icon.

• Extra characters at the end. Same warning as above.

Does anyone have a rock-solid email validation solution for Power Apps that will only accept correctly formatted emails with no leading or ending spaces?

I hope you can help
Colin

[AJ_Z · Accepted solution]

I usually use something like this:

If(
    IsMatch(
        DataCardValue3.Text,
        "^([a-zA-Z0-9_.-])+@(([a-zA-Z0-9-])+.)+([a-zA-Z0-9]{2,4})+$"
    ),
    Check,
    Icon.Warning
)

for the color box i usually go with something like:

If(
    IsMatch(
        DataCardValue3.Text,
        "^([a-zA-Z0-9_.-])+@(([a-zA-Z0-9-])+.)+([a-zA-Z0-9]{2,4})+$"
    ),
    Green,
    Red
)

I sometimes switch this up when I validate internal vs external emails by validating the domain.

so if I want to validate and internal email address here is an example of what i might do:

If(
    IsMatch(
        DataCardValue3.Text,
        "^([a-zA-Z0-9_.-])+@(([a-zA-Z0-9-])+.)+([a-zA-Z0-9]{2,4})+$"
    ) And Last(
        Split(
            DataCardValue3.Text,
            "@"
        )
    ).Result in [
        "advancedanalysts.co.uk",
        "microsoft.com"
    ],
    Green,
    Red
)

this now makes it check to see that the bit after the "@" ends in one of the domains i listed. for my example there the email would be valid if it was aj_z@advancedanalysts.co.uk.

I use this logic sometimes to list acceptable domains in my condition as well.

I hope this is helpful let me know if you have questions

[AJ_Z]

If you want to keep it simple go with the first solution but if you want to validate specific domains take a look at the last solution 🙂

[hemrhk · Accepted solution]

@PowerStar321 

Try this it will not allow special characters in the Email organization, space in the domain.

If(
    IsMatch(
        DataCardValue3.Text,
        "^[\w-\.]+@([\w-]+\.)+[\w-]{2,4}$"
    ),
    Check,
    Icon.Warning
)

------------------------------------------------------------------------------------------------- 

If it solved your problem give a kudo and accept it as a solution. 

Follow and Subscribe 365 Stack for more updates. 

[iAm_ManCat]

Some of the solutions provided in this thread don't validate against RFC5322 email standards.

I have a blog post that covers email validation according the the RFC5322 standard - you can copy the code in there for use in your apps 🙂

Email validation in Power Apps - iAm_ManCat Blog (iammancat.dev)