Answered

Full Names Split to First and Last

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I'm trying to extract customer names but the problem is that the full name is in one element and I need a First Name element and a Last Name element. I'm extracting the full name via "get details of a UI element in window" (Jim J Adams) but I need just Jim as First Name field and then Adams as Last Name field

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (1)

Sort by

MichaelAnnis 5,727 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

We've talked about it in private message, but for others- this works well when every customer has a middle initial but if a customer doesn't have a middle initial listed, it throws an error for TextList2 being out of range.

So I'm looking for a solution to use for when clients may or may not have an initial. Just FYI- I do not need the middle initial. All I need is first and last name as variables from this data extraction.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Is there a way to add a random character to the middle initial?

For example: Client does not have a middle initial (Joe Smith). Bot extracts the value and puts a random character after the first separator ( which is a space), then it adds another space so now we have 2 space separators (Joe J Smith).
If the client already had a middle initial (Joe J Smith), then the bot would still add the random character and we would still only have 2 separators (Joe XJ Smith), and thus could use the List Solution.

What would the vehicle be for adding that random character?

Was this reply helpful? Yes No
Verified answer

MichaelAnnis 5,727 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Was in a meeting...here you go. Same flow, but tested both with and without the middle initial to show result:

Was this reply helpful? Yes No
Highboy 1,187 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

SET Name TO $'''First Middelname Lastname'''
Text.SplitText.Split Text: Name StandardDelimiter: Text.StandardDelimiter.Space DelimiterTimes: 1 Result=> TextList
SET Firstname TO TextList[0]
SET Lastname TO TextList[TextList.Count - 1]

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I ended up using Pad text to the right side and used spaces and a comma. I'll probably go back and redo it the way you guys have done it. Thanks for your input!!

Was this reply helpful? Yes No