web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Concatenate First Name...

Power Apps

Answered

Concatenate First Name from a Person Column from SP List

(0) Share

Report

Report

Posted on by RoadRunner

11

I need to display the first name only from a Person Column in SP List. I am using this code in the Text property

ThisItem.'Assigned To'.DisplayName'

It works fine and gives me the full name. I have searched everywhere for a simple solution that does not involve a flow.

Thank You,

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@RoadRunner - you can obtain the first name by adding the Office 365 Users connector as a data source, and then adding either of the below onto the Text property of a Label:

First(Office365Users.SearchUser({searchTerm: ThisItem.'Assigned To'.Email})).GivenName

Office365Users.UserProfile(ThisItem.'Assigned To'.Email).GivenName

Was this reply helpful? Yes No
Verified answer

RoadRunner 11 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Imran,

I wanted something minimal. I kept poking around until I got it to work after posting this message a few minutes ago. Here is the code I am using:

First(Split(ThisItem.'Assigned To'.DisplayName," ")).Value

I kept using .Result but it would not work with DisplayName. Finally after watching the code prompts I tried Value and it worked.

Thanks Again.

Was this reply helpful? Yes No

Join the conversation