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

All responses (3)

Answers (0)

Sort by

Rajkumar_M 3,747 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
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.
rzainm 107 on at

Like
a
(0)

Report
Copy link

Link copied!

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.
Rajkumar_M 3,747 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
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!