Last name's initial letter is sometimes blank

(0) Share

Report

Posted on by rzainm

107

I want to get the first and last name initials of the user.

I used DisplayName: User().FullName for _currUser.DisplayName, and the code below to get the initials but for some cases (3 names or more) this won't work.

Concatenate(Left(_currUser.DisplayName, 1), Left(Right(_currUser.DisplayName, Find(" ", _currUser.DisplayName)), 1))

I know there is MyProfileV2() but I wish using that will be my last option.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Rajkumar_M 3,741 Super User 2025 Season 2 on at

Like (1)

Report
Hi

Try this

Concatenate(
Left(
Trim(_currUser.DisplayName),
1),
If(
Len(
Trim(
Right(
_currUser.DisplayName,
Len(_currUser.DisplayName) - Find(" ", Trim(_currUser.DisplayName))
))
) > 0,
Left(Trim(
Right(
_currUser.DisplayName,
Len(_currUser.DisplayName) - Find(" ", Trim(_currUser.DisplayName))
)),
1
),
""
))

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
rzainm 107 on at

Like (0)

Report

Hi @Rajkumar_404

thanks for the response. I tried using your code but it works for people having one first name. If user has 2 or more first names eg. Angel Mae Smith, etc. it will get the initials for Angel Mae.

Was this reply helpful? Yes No
Rajkumar_M 3,741 Super User 2025 Season 2 on at

Like (0)

Report
Try this

Concatenate(
Left( User().FullName & " " , 1),
" ",
Mid(
User().FullName & " ",
Find(" ", User().FullName & " " ) + 1,
1
),
" ",
Right(
User().FullName & " " ,
Len(User().FullName & " " ) - Find(" ",User().FullName & " " , Find(" ",User().FullName & " " ) + 1)
)
)

Thanks!

Was this reply helpful? Yes No