Announcements
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.
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?
Yes, my full name column in my dataverse table is a calculated column
Don't think that is supported within a calculated column, have you tried to utilize formula column to do something like this?
That works for full name, but if I only wanted the first letter of the middle name how would I go about that? Thanks!
ahh, sorry about that, here you go:
Concatenate('First Name',If(Len('Middle Name')>0," ",""),Left('Middle Name',1),If(Len('Last Name')>0," ",""),'Last Name')
Thank you!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 483
WarrenBelz 399 Most Valuable Professional
11manish 327
