Unanswered

Get first letter of string

(0) Share

Report

Posted on by ChattyLinkin

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.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

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?

Was this reply helpful? Yes No
ChattyLinkin 51 on at

Like (0)

Report

Yes, my full name column in my dataverse table is a calculated column

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

Hi @ChattyLinkin ,

Don't think that is supported within a calculated column, have you tried to utilize formula column to do something like this?

Concatenate('First Name',If(Len('Middle Name')>0," ",""),'Middle Name',If(Len('Last Name')>0," ",""),'Last Name')

I verified this worked with a middle name or no middle name on the Contact entity:

Was this reply helpful? Yes No
ChattyLinkin 51 on at

Like (0)

Report

That works for full name, but if I only wanted the first letter of the middle name how would I go about that? Thanks!

Was this reply helpful? Yes No
Verified answer

Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report
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')

Was this reply helpful? Yes No
ChattyLinkin 51 on at

Like (0)

Report

Thank you!

Was this reply helpful? Yes No