Split Name and LastName

[Jethrooooo12]

Hi,

I am trying to split the first and Lastname from data I parsed from email/outlook to have a separate column on Sharepoint.

I can get the first name just fine. My problem is the LastName. Any idea?

[abm]

First try to get the full name. Then use the split with spaces to get firstname and lastname.

[Jethrooooo12]

Hi @abm 

Just kinda confused here now. How do you split using the spaces?

Thank you for responding to my query.

[Jethrooooo12]

@abm 

Scratch it. I got it resolved.

Thanks!

[v-bacao-msft · Accepted solution]

Hi @Jethrooooo12 ,

Please do like this:

Expression reference:

split(variables('LastName'),' ')[1]

Best Regards,