Unanswered

How to change Last Name to First Name in power automate?

(0) Share

Report

Posted on by hgartner

I have a flow that when an item is created, an email is sent to the person who created the item.
In the body of the email to be sent, I put the "Created by", but the format is first the "last name" and then the "first name", but I would like to have the first name and then the last name. Is there any way to create an expression to change this?

Example:
how it is sent: Gartner, Henrique
how would I like it to be: Henrique Gartner

Thanks

Categories:

Using flows

I have the same question (0)

All responses (8)

Answers (4)

Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (1)

Report
Hi @hgartner,

You could use an expression for that with a split and concat function. Obviously this only works if there is always a comma character as a separator.

concat(split(outputs('Compose'), ',')[1], ' ', split(outputs('Compose'), ',')[0])

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (1)

Report
Hi @hgartner,

I forgot about the leading space character.

I have added a replace function for that in the expression:

concat(replace(split(outputs('Compose'), ',')[1], ' ', ''), ' ', split(outputs('Compose'), ',')[0])

Was this reply helpful? Yes No
hgartner 65 on at

Like (0)

Report

Hi Dennis,
Thank you very much. The expression works for the Compose whose value is entered manually. But when I put a value from a sharepoint list, it gives the following error in the split:

Could not process template language expressions in 'Compose_2' entries of action in row '1' and column '27301': 'Template language function 'split' expects first parameter to be of type string . The value provided is of type 'Array'.

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (1)

Report

Hi @hgartner ,

Can you place the second compose action also within the apply to each action?

Was this reply helpful? Yes No
hgartner 65 on at

Like (0)

Report

Yes, but the output of compose 2 does not appear in dynamic content to add it to the body of the message to be sent in the email.

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (1)

Report

Hi @hgartner,

That compose action is just an example of presenting the new name. You should also be able to use that expression directly in the body (corpo) of the e-mail action via the expression (expressão) editor.

Was this reply helpful? Yes No
hgartner 65 on at

Like (0)

Report

Ahh, I get it. I was using the output of compose to add to the message body. I made the expression directly in the body of the message and it worked.
Just a note, I forgot to mention that the name is made up of a bracketed reference. Would it be possible to delete?
For example: Gartner, Henrique [Netherlands]
Result after applying the expression: Henrique Gartner

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (1)

Report
Hi @hgartner,

Can you use the following expression for the names with the bracketed reference:

concat(replace(split(split(outputs('Compose'), ',')[1], '[')[0], ' ', ''), ' ', split(outputs('Compose'), ',')[0])

Was this reply helpful? Yes No