Answered

Taking a name from an text input and forming an email address to it

(0) Share

Report

Posted on by JL82

156

I created an app where a user can input an employee's name and I'm trying to take that name and make it into our company email.

I was able to get this to work however, every time someone runs the app, and the text box is empty, I get this error

"The second argument to the 'Left' function is invalid.",. Only after someone types something on the text input box will the error go away

What do i need to change so that the error wont appear even if it is blank? Please help. Thank you

Formula

Text(Lower(Substitute(Proper(Left(ThisItem.'Employee Name',Find(" ",ThisItem.'Employee Name')-1)&"."&Proper(Mid(ThisItem.'Employee Name',Find(" ",ThisItem.'Employee Name')+1,Len(ThisItem.'Employee Name')-Find(" ",ThisItem.'Employee Name')))), " ", "")) & "@companyname.com")

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (2)

Sort by

Verified answer

v-yueyun-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi , @JonathanL82
You may try to use this code :

Lower( Proper( First( Split(ThisItem.'Employee Name'," ") ).Value)& If(CountRows(Split(ThisItem.'Employee Name'," "))=1,"", ".")) & Concat( LastN( Split(ThisItem.'Employee Name'," ") , CountRows( Split(ThisItem.'Employee Name'," ") )-1) ,Value ,"") & "@companyname.com"
Or update your code to this:
Text( Lower(Substitute(Proper( If(Find(" ",Label3.Text) <> Blank() , Left(Label3.Text, Find(" ",Label3.Text)-1) , "" ) & If(Find(" ",Label3.Text) <> Blank() , "." , "") &Proper(Mid(Label3.Text,Find(" ",Label3.Text)+1,Len(Label3.Text)-Find(" ",Label3.Text)))), " ", "")) & "@companyname.com" )

Your error code will exist when the Name without sapce like this:
AniyahahaZhang

If this reply can help you , you can click mark this reply as solution, thanks in advance!

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,432 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @JonathanL82 ,

If you simply want Firstname.Lastname@companyname.com if there is something in the Employee Name

If( Len(ThisItem.'Employee Name') > 0, With( { _Name: Split( ThisItem.'Employee Name', " " ) }, Proper(First(_Name).Value) & "." & Proper(Last(_Name).Value) & "@companyname.com" ) )

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
JL82 156 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-yueyun-msft THank you! this works except for one thing, the first letter in the last name stays upper case if it is typed upper case on the text input box. How can this be changed so it will go lower case too just like the first name.

Was this reply helpful? Yes No
JL82 156 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @WarrenBelz thank you for your reply. This one works too but the names if typed in upper case will not be changed into lower case. How can this be arranged?

Was this reply helpful? Yes No
v-yueyun-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
HI , @JonathanL82
Yu can try :
Lower( Proper( First( Split(Label3.Text," ") ).Value)& If(CountRows(Split(Label3.Text," "))=1,"", ".") & Concat( LastN( Split(Label3.Text," ") , CountRows( Split(Label3.Text," ") )-1) ,Value ,"")) & "@companyname.com"
Text( Lower(Substitute(Proper( If(Find(" ",Label3.Text) <> Blank() , Left(Label3.Text, Find(" ",Label3.Text)-1) , "" ) & If(Find(" ",Label3.Text) <> Blank() , "." , "") &Proper(Mid(Label3.Text,Find(" ",Label3.Text)+1,Len(Label3.Text)-Find(" ",Label3.Text)))), " ", "")) & "@companyname.com" )
Both can realize:

If this reply can help you , you can click mark this reply as solution, thanks in advance!

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
JL82 156 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-yueyun-msft actually your second formula works Thank you sooo much!

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

Like
a
(2)

Report
Copy link

Link copied!

Hi @JonathanL82,

Simply change Proper to Lower in the code. You will find it significantly less complex and resource demanding than what you have currently.

Was this reply helpful? Yes No
JL82 156 on at

Like
a
(1)

Report
Copy link

Link copied!

@WarrenBelz this one works too! thank you very much!

Was this reply helpful? Yes No