Split First Name and Last Name of User Name in Power Automate Desktop

[Anonymous]

Hello, Can someone help me with the following question?

I would like to Split the Username as First Name and Last Name. However, I am stuck when the user has more than 2 words in the Name.

For Example: Username = Master the Art

I prefer

First Name - Master

Last Name - The Art ( Last name should be after the First word of the username irrespective of number of words the user name has)

Currently, This is how I tried but it works only when the Employee Name has '3' words in it. However, I need the Employee's Last name should be "The Art"

Few more examples are..

Employee Name - Chair has Four legs

First Name - Chair; Last Name - has Four legs

Employee Name - Water Purifier

First Name - Water; Last Name - Purifier

[wnzn · Accepted solution]

Funny employees you have. 🙂

If you are working with a TextList with a variable amount of items, you can use a for each loop to go through each of them and use the Set variable action in that for each loop to update the last name variable for each item. The first name can still be done before the for each loop as it is currently: "TextList[0]". Take a look at this to get an idea: For each loop actions - Learn | Microsoft Docs

[MichaelAnnis]

Use Parse Text to get the position of the first space; ensure you use the "First occurrence only" option.

Notice, to find a space is %' '% ; note the space is in between the apostrophes.

Get subtext from start to the Position number found above for the first name:

Get subtext from %Postition + 1% to the end of text for the last name:

That's how to split it.  You will need to create two new lists or a datatable to keep the records, because when you throw this into a loop, these variables will be overwritten, so:

Start with employeename list

Create List %FirstNames%

Create List %LastNames%

For each %CurrentItem% in %EmployeeNames%

    ~Do the above

    Add %FirstName% to %FirstNames%

    Add %LastName% to %LastNames%

End (For each)

Then you will have two lists that are in the same order.

Good luck!