Answered

Help with Gallery displaying SharePoint displayname field

(0) Share

Report

Posted on by The1AndOnlyPJ

Due to some settings I have no control over, the SharePoint display name in my org is configured as ''Surname, FirstName (Department name)'

I would really like to just display 'FirstName Surname' for the items in my PowerApps gallery. I have looked around and found @tscott07 entry on this post, but that has only got me to the point where I am now able to display 'FirstName (Department name) Surname'. I need some help to enhance this further and remove '(Department name) please.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

WarrenBelz 154,528 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @The1AndOnlyPJ ,

Are these separate fields or a string

Surname, FirstName (Department name)

If a string

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

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.

Was this reply helpful? Yes No
The1AndOnlyPJ 13 on at

Like (0)

Report
Copy link

Link copied!

Many thanks @WarrenBelz , this has given me 'Surname, FirstName' which is a step closer, but I was hoping to be able to display 'FirstName Surname'. Is this possible?

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,528 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @The1AndOnlyPJ ,

This should work - it will help you to take a moment to understand what this is doing

With( { wName: First( Split( YourTextField, " (" ) ).Result }, Last( Split( wName, ", " ) ).Result & " " & First( Split( wName, ", " ) ).Result )

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.

Was this reply helpful? Yes No
The1AndOnlyPJ 13 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz That has worked a dream. Many thanks. I think I understand what is going on with this solution, just would never have got there myself!

Was this reply helpful? Yes No