Answered

auto fill text field from display name

(0) Share

Report

Posted on by Wei Ming Leong

313

Hi all,
Thank you for taking your time to look at my question.
i making a sharepoint list that have firstname, lastname, DisplayName, emailaddress etc.

I have done using Concatenate firstname and lastname to do for display name.

How can i have it auto fill with either Displayname or First Name & Last Name, and without spacing in each word.
For example.
First Name : Peter John
Last Name : Leong
Display name : Peter John Leong

Email address : peterjohn.leong@emaildomain.com

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Digital 1,207 on at

Like (0)

Report
Copy link

Link copied!
For first name from display name

First(Split(DisplayName," ")).Result

For last name
Last(Split(DisplayName," ")).Result

Was this reply helpful? Yes No
Wei Ming Leong 313 on at

Like (0)

Report
Copy link

Link copied!

HI Digital,
that does not work the way i want.
the outcome should be
firstname.lastname@emaildomain.com

Was this reply helpful? Yes No
Digital 1,207 on at

Like (0)

Report
Copy link

Link copied!
Probably a more elegant way but it works for two names and three names.

With( { wNumberOfNames:CountRows(Split(Label2.Text," ")) }, If( Mod(wNumberOfNames,2) = 0, Concat(Split(Label2.Text," "),Result,"."), Replace( Concat(Split(Label2.Text," "),Result,"."), Find( ".", Concat(Split(Label2.Text," "),Result,".") ),1,"" ) ) ) & "@domain.com"

Peter John Leong will become PeterJohn.Leong@domain.com

Peter Leong will become Peter.Leong@domain.com

This solution is only for display name with up to three names

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @WeiMingLeong,

Do you want to auto fill email address based on first name and last name?

Could you please share a bit more about the scenario?

Not sure where you operate this action, in a Form? I just assume that you want to auto fill the EmailAddress field based on the first name and last name.

Set the Text Input Default property or Label Text property as below:

Concatenate( Concat( Split( Label6.Text,// Here displays the first name " " ), Result, "" ), ".", Label7.Text,// Here displays the last name "@emaildomain.com" )

Note that you could replace the Label name with your real text control name.

Was this reply helpful? Yes No
Wei Ming Leong 313 on at

Like (0)

Report
Copy link

Link copied!

Hi Qi, Thank you for your reply.
this formula work.

Was this reply helpful? Yes No