Answered

Formula Help for Email Validation

(0) Share

Report

Posted on by Lana

This is my formula for "Submit" button.

If(Form_2.Valid&&IsMatch(DataCardValue108.Text, Email)=true,SubmitForm(Form_2);UpdateContext({ShowRequired:"N"});ResetForm(Form_2),UpdateContext({ShowRequired:"Y"}));

I have a form with some fields which are conditionally required (Ex: Department Drop down selected is "IT", make filling out "Development Effort" required field) and an email address field so that is the reason why I am checking In Form_2.Valid.

I am trying to combine my email validation(DataCardValue108 field) as well. But I am getting an error saying IsMatch has some invalid arguments.

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Try
If(Form_2.Valid&&IsMatch(DataCardValue108.Text, Email),SubmitForm(Form_2);UpdateContext({ShowRequired:"N"});ResetForm(Form_2),UpdateContext({ShowRequired:"Y"}))

If you have errors explain further Form2.Valid
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Lana ,

Could you please share a bit more about the error message?

Based on the formula that you mentioned, I could not find any syntax error with it. I have made a test on my side, the IsMatch function works well.

Please consider modify your formula as below:

If( Form_2.Valid = true && IsMatch(DataCardValue108.Text, Match.Email) = true, SubmitForm(Form_2);UpdateContext({ShowRequired:"N"});ResetForm(Form_2), UpdateContext({ShowRequired: "Y"}) );

Note: I assume that the DataCardValue108 is a Text Input box inside your Edit form. Please make sure you have referenced proper email address field in your above If function.

Regards,
Lana 90 on at

Like
a
(0)

Report
Copy link

Link copied!

I found the answer. I had just Email instead of Match.Email.

Thank you for taking the time to answer.