How to change DisplayName to first and last name

(0) Share

Report

Posted on by AuburnMist

239

Hi folks,

I've added a person type column to my form and when the person is selected from the Outlook directory, I want to display their first name and last name in a separate text input field.

Out of the box, I can display the selected person's DisplayName by (cmbEmployeeName.Selected.DisplayName), but this reads (in our organisation) as: LastName, First Name + Initials + Region such as Parker, Peter PP [ATL].

Is there a way that I display it instead as Peter Parker?

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

JeanL 53 on at

Like (0)

Report
Copy link

Link copied!

Hi, on the app I'm working on, I have this in a label:
Concatenate("Welcome ", User().FullName)
So far, none of my testers has said it was wrong.

Was this reply helpful? Yes No
SebS 4,801 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @AuburnMist

If I good remember, People column uses O365 users Connector try then.

(cmbEmployeeName.Selected.GivenName&" "&cmbEmployeeName.Selected.Surname)

Sorry, The above should do the Trick. The property of the GivenName should retrieve the First name and Surname will Give You the Surname 🙂

Was this reply helpful? Yes No
AuburnMist 239 on at

Like (1)

Report
Copy link

Link copied!
Thank you both for your replies, unfortunately, neither solution works. I continued to research and found this code, which works perfectly.
First(Office365Users.SearchUser({searchTerm:cmbEmployeeName.Selected.DisplayName})).GivenName&" "&Last(Office365Users.SearchUser({searchTerm:cmbEmployeeName.Selected.DisplayName})).Surname

Was this reply helpful? Yes No
MVP-Phipps 3,521 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
You should be able to do:

First(Office365Users.SearchUser({searchTerm:cmbEmployeeName.Selected.DisplayName})).GivenName&" "&Last(Office365Users.SearchUser({searchTerm:cmbEmployeeName.Selected.DisplayName})).Surname

Let me know if this works...

Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/
YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg
Twitter: https://twitter.com/phipps0218

Was this reply helpful? Yes No
Verified answer

AuburnMist 239 on at

Like (1)

Report
Copy link

Link copied!

Yup! That's it! 🙂

Was this reply helpful? Yes No
stingray 196 on at

Like (0)

Report
Copy link

Link copied!

Hi String Interpolation is now available in PowerApps, will help read text joins using dynamic strings from data sources.

$"Text {Dynamic Content} Text"

You can also use Office365Users.UserProfileV2() is probably a bit more efficient than Office365Users.SearchUserV2() which is more for use in a people picker combobox.

Thanks

Was this reply helpful? Yes No
Rahul_Tantia 22 on at

Like (0)

Report
Copy link

Link copied!

You can simply add a database connection to Office365Ussers
Then in the Text Column write Office365Users.MyProfile().DisplayName

Was this reply helpful? Yes No
MWibisono 75 on at

Like (0)

Report
Copy link

Link copied!

String or other functions?

Was this reply helpful? Yes No