Answered

Use of People Field

(1) Share

Report

Posted on by RJF61

1,265

I have a column in my SharePoint list where I select a "Person or Group". In my case it is a Person as shown in the 1st pic. I only want to display the Last Name; however, when I select "Last name" (as shown in the 2nd pic) I still receive the entire name.

Am I doing something wrong or can I set up another column to extract the Last name from the initial Person information?

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (1)

Sort by

Suggested answer

EE-04041031-0 106 on at

Like (0)

Report
Copy link

Link copied!

You can't directly extract just the last name from a "Person or Group" column in SharePoint views. The field always displays the full name. To show only the last name, create a separate calculated column or do the transformation in Power Apps or Power Automate.

Power Apps solution:

Use this formula to extract last name:
Last(Split(ThisItem.Person.DisplayName, " "))

Power Automate or calculated column option:

Use a flow or calculated column with a formula like:

=RIGHT([Person],LEN([Person])-FIND(" ",[Person]))

Was this reply helpful? Yes No
stampcoin 5,153 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@RJF61 Hi,

According to your screenshot, you selected Name for the 'Show field' but not Last name.

can you double check that ?

Was this reply helpful? Yes No
RJF61 1,265 on at

Like (0)

Report
Copy link

Link copied!

Hello @stampcoin

Actually, I did change after I sent the email. The Last name does display in SharePoint as expected but in the PowerApp the full name still is displayed.

Thanks

Was this reply helpful? Yes No
RJF61 1,265 on at

Like (0)

Report
Copy link

Link copied!

Hi @EE-04041031-0

So I'm not totally clear on your options...

Is this option used as the "Text" in a Text Label?

Power Apps solution:
Use this formula to extract last name:
Last(Split(ThisItem.Person.DisplayName, " "))

Is the following for a calculated column in the SharePoint list?

Power Automate or calculated column option:
Use a flow or calculated column with a formula like:

=RIGHT([Person],LEN([Person])-FIND(" ",[Person]))

Was this reply helpful? Yes No
EE-04041031-0 106 on at

Like (0)

Report
Copy link

Link copied!

@RJF61 Yes, you’ll need to create a new Single line of text column in your SharePoint list called “Last Name”.

In your Canvas app, extract the last name from the selected Person field like this:

Last(Split(PersonCard.Selected.DisplayName, " "))

When the form is submitted, the extracted last name will be saved to the new column in your SharePoint list.

Was this reply helpful? Yes No
RJF61 1,265 on at

Like (0)

Report
Copy link

Link copied!

@EE-04041031-0

I do. The SharePoint "Person" column is titled PMMgr.

Was this reply helpful? Yes No
Suggested answer

w.p 8,345 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@RJF61

The first and last name aren't available through the SharePoint connector in Power Apps.

You can use the Office365Users connector to retrieve the last name.

Was this reply helpful? Yes No
RJF61 1,265 on at

Like (0)

Report
Copy link

Link copied!

@EE-04041031-0

I created the additional SP field. Where does this PowerApp action occur?

Was this reply helpful? Yes No
Suggested answer

EE-04041031-0 106 on at

Like (0)

Report
Copy link

Link copied!
Use of People Field

@RJF61 Great, since the sharepoint person column doesn't reflect other fields, you can create a new text column and patch the selected last name directly, follow these steps:

Steps to Save Only the Last Name from a Person Field in SharePoint via Power Apps:

Create a Single line of text column in SharePoint called "Last Name".

In Power Apps, add the "Last Name" data card to your form.

Set the Text Input’s Default to: Last(Split(PersonDropdown.Selected.DisplayName, " "))

On form submit, the last name will be saved to SharePoint.

Was this reply helpful? Yes No
RJF61 1,265 on at

Like (0)

Report
Copy link

Link copied!

@EE-04041031-0

This is not working in my PowerApp. I receive errors with...

Last(Split(DataCardValue7.Selected.DisplayName," "))

or

Last(Split(PMMgr.Selected.DisplayName," "))

Was this reply helpful? Yes No