You’re offline. This is a read only version of the page.
51
Hi all,
I am trying to get a person's initials from a middle name column to put into a full name column. I already have their first and last names in the full name column, but I can't seem to figure out how to get the first initial of their middle name. Any help would be greatly appreciated.
Thank you!
ahh, sorry about that, here you go:
Share
Report
All responses (
Answers (
Concatenate('First Name',If(Len('Middle Name')>0," ",""),Left('Middle Name',1),If(Len('Last Name')>0," ",""),'Last Name')That works for full name, but if I only wanted the first letter of the middle name how would I go about that? Thanks!
Hi @ChattyLinkin ,
Don't think that is supported within a calculated column, have you tried to utilize formula column to do something like this?
Yes, my full name column in my dataverse table is a calculated column
Hi @ChattyLinkin ,
Where are you trying to do this? Is it in a calculated column in Dataverse, Power FX formula Dataverse column, Power Automate flow, Power App?
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
17
#3
ankit_singhal
11
Super User 2025 Season 1
