Split First Name and Last Name from a SharePoint Single Line Field

[Anonymous]

Hello,

I have a SharePoint List with a field named 'PM contact', I am trying to split and return 2 different values, one for First Name and the other for Last Name.

I tried the expression below, but it doesn't seem to be working

first(split(triggerbody()?['PM_x0020_contact'],' '))

last(split(triggerbody()?['PM_x0020_contact'],' '))

Anyone knows of any alternative method or the correct expression I should use here for this purpose?

Thank you!

[Pstork1]

Is the field in the list a person/group column?  Also, since you are doing a Get items to get the list items you'll need to put your compose inside an Apply to each loop and either save the value as a variable for use outside the loop or use it while inside the loop.  For a people column it should be

first(split(triggerbody()?[ 'PM_x0020_contact' ]?['DisplayName'], ' ' ))
last(split(triggerbody()?['PM_x0020_contact']?['DisplayName'],' '))

[Anonymous]

Thank you @Pstork1.

The field "PM contact" is a single line of text.

And the error I got was the following:

"Unable to process template language expressions in action 'Compose' inputs at line '1' and column '28258': 'The template language function 'split' expects its first parameter to be of type string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#split for usage details.'."

I added an Apply to Each as per below, but I'm still getting a similar error:

I am not great with expressions, any ideas?

[Pstork1 · Accepted solution]

If its a single line of text field then your first code should probably have worked.  I suspect its something with the JSON field name you are using.  If you remove what you have in the compose and just insert the contact field from Get Items and then hover over it what does the tooltip say?  That will be what should go where you currently are using triggerbody()?['PM_x0020_contact']

[Anonymous]

@Pstork1 I get 

{

    "inputs": "@items('Apply_to_each_4')?['PM_x0020_contact']"

} 

So should the expression become as follows instead?

first(split(@items('Apply_to_each_4')?['PM_x0020_contact'],' '))

[Anonymous]

@Pstork1 I got it to work with this:

first(split(items('Apply_to_each_4')?['PM_x0020_contact'],' '))

Thanks!

[Pstork1]

For a single line of text that would be the right code.