Email Verification

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi ,

I've a column in my power app where the user enters email

the required filed is true

when the user enters the email is their any way that I could validate the email address

I don't need to validate on the basis of domain , I just need the mail should be in email format if not I need the datacard should display an error message and turn the datacard column color to red could any one help me on this

I tried to add an icon (warning ) inside the data card and set it icon function into following , but it is showing an error

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

Categories:

Building Power Apps

I have the same question (0)

All responses (19)

Answers (3)

Sort by

WarrenBelz 156,373 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Why not simply

If( IsMatch( DataCardValue2_6.Text, Match.Email ), Color.Green, Color.Red )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!

Hey @WarrenBelz

Be Careful with Match.Email - it doesn't actually validate emails!

The string it uses for validation is:

Which means I can put any old crap in my textinput before the last @ and it will validate it as a valid email even if completely wrong!

Cheers,

Sancho

Was this reply helpful? Yes No
iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hey @Anonymous

You are using colors in your Icon property - the Icon property expects an Icon-type - you need to move this code to the Color/Fill property of the icon 🙂

Cheers,

Sancho

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks for your advice ,
How do u suggest me to do proper email validation for my app
I cann't use for domain validation since I got users from different entity
I their any way that I could validate like if the email entered by the user is not in the office 365 users it should show an error
is it possible ?

Was this reply helpful? Yes No
WarrenBelz 156,373 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks @iAm_ManCat ,

I actually do not use it myself, but ran a test here and it appears to work

Was this reply helpful? Yes No
iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

it only validates if there's:

(literally any characters) @ (literally any characters) DOT (literally any characters)

It's not a valid email checker as it means people can enter invalid emails! just because a valid email also matches that pattern doesn't make it a valid one 🙂

Try put this text in and ask it if it's a valid email:

!($*&^!(@@@@@@%^.Harker@@.!&$*!@

Was this reply helpful? Yes No
iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Yes, if you wanted to validate against internal emails only then that could work - you'd use Office365Users.SearchUser function - but in that case why not use a people picker? if you create a person column you should be able to insert that into a form and it will create the combobox for you that only takes in internal people

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi , Thanks for the response

The people picker step u mentioned , I don't get it
what I was planning to do is to pass a code in my onselect of my submit button , but its showing an error
Could u please help met fix it
If(
Office365Users.UserProfileV2(DataCardValue2_5.Text).id <> "",
SubmitForm(Form1_5),
Notify(
"Please enter a valid email address",
NotificationType.Error
)
)

this is working but if the user enter's a value which is not in the office 365 email its display a very large error

please help me on this

Was this reply helpful? Yes No
iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
If( Len(DataCardValue2_5.Text)>0 && Office365Users.UserProfileV2(DataCardValue2_5.Text).id <> "", SubmitForm(Form1_5), Notify("Please enter a valid email address",NotificationType.Error) )

Could you try using that instead - that should check for if there is anything in the box first, not entirely sure it will negate the error - but we can try something else if that doesn't work 🙂

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi

Its working but the problem is the error displaying mode

if u see the error screenshot the user won't be able to understand the reason behind it
is there is any way that I could hide it and display only this
Notify("Please enter a valid email address",
or else is their is any other possibility that we could check the same when the user enters the mail in the Email ID column
I got stuck in this man

Was this reply helpful? Yes No