Answered

Appending Form Field Entry with an Email Domain

(0) Share

Report

Posted on by dedgerton1

I have a 5-field form that only displays 4 fields to the user as two fields are set to either hide/display based on a toggle control. Works perfectly up until the moment I try to append one of them with an email domain (see student_email_address). I'm attempting to make the form foolproof by adding the domain for the user while also preventing typos. I can populate my Email column in my Collection using the IF function, but it doesn't like the "@" symbol. Any suggestions?

Screen Shot 2022-03-30 at 4.23.38 PM.png

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

EdViegas 436 on at

Like
a
(1)

Report
Copy link

Link copied!
Maybe what you want is:

If( Not( IsBlank(DataCardValue_CampusID.Text) ), DataCardValue_CampusID.Text & "@student.school.edu", DataCardValueEmail.Text )

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Try

If(Not(IsBlank(DataCardValue_CampusID)),Concatenate(DataCardValue_CampusID.Text,"@student.school.edu"),DataCardValue_Email.Text)

Was this reply helpful? Yes No
dedgerton1 83 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks! That works for the collection, but the Patch function isn't adding this to the respective cell in Excel. What could I be missing here in terms of updating a cell with an email value?

Was this reply helpful? Yes No