Answered

Validate Emails (Text Input) Separated by Semicolon to Match Several Domains?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a text input for email addresses and the user can provide a single email or multiple emails separated by a semicolon. I need to validate the email(s) to match 1 of 2 domains (abc.com or def.com). My issue is that the code below works great, but how do I accomplish this validation for multiple emails separated by a semicolon?

// WORKS - Validate email text input as 1) Valid email, 2) Whitelist ABC & DEF domains 
If(IsMatch(TextInput1.Text, 
 "^([a-zA-Z0-9_.-])+@(([a-zA-Z0-9-])+.)+([a-zA-Z0-9]{2,4})+$"
 ) And
 Last(Split(TextInput1.Text, "@")).Result 
 in ["abc.com", "def.com"]
 ,
 Notify("Email IS valid", NotificationType.Success),
 Notify("Email not valid", NotificationType.Error)
)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

sgtsnacks 62 on at

Like (2)

Report
Copy link

Link copied!
You can use Split(string,delimiter) combined with a ForAll() to achieve this. You can also use the result to add to your notification to identify the address in question.

Clear(mailtest);ForAll(Split(txt_Mails.Text,";").Result, If(IsMatch(ThisRecord.Result, "^([a-zA-Z0-9_.-])+@(([a-zA-Z0-9-])+.)+([a-zA-Z0-9]{2,4})+$" ) And Last(Split(ThisRecord.Result, "@")).Result in ["abc.com", "def.com"] , Collect(mailtest,ThisRecord.Result & " is Valid");Notify(Last(mailtest.Value).Value,NotificationType.Success), Collect(mailtest,ThisRecord.Result & " is Not Valid");Notify(Last(mailtest.Value).Value,NotificationType.Error)) )

I've added a collection (mailtest) statement above to capture the results and display them in a ListBox, for demonstration purposes. This may not be required in production.

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

Like (0)

Report
Copy link

Link copied!

@sgtsnacks - This worked - thank you!

Was this reply helpful? Yes No