Splitting a string not working

(0) Share

Report

Posted on by Mattw112b

1,088

I have a returned value from a Power Automate Flow. I am trying to split into First name and last name.

Here's code:

Screenshot 2023-10-03 175646.png

So, it works for last name, but doesn't work for first name even though they are pretty much the same logic?

Screenshot 2023-10-03 175618.png

What am I missing here? There's no errors. In the screen capture above you can see returned name "Paul Genuario" and Last name "Genuario", but First name is blank?

Thanks,

Terry

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

Michael E. Gernaey 53,958 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hello @Mattw112IG

Actually I believe its pretty simple lol and I only say that cause usually im blind hehe

But in your picture.. there is a Space before the first name.. so the FIRST will return that space "" aka empty.

woot for my new glasses.

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
Verified answer

Mike2500 1,247 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

In your screen shot, ReturnedName starts with a space: "Paul Genuario". If you can't remove the space upstream, just use a trim to get rid of the leading (or trailing) space: split(trim(returnedname)," ")

Was this reply helpful? Yes No
Mattw112b 1,088 on at

Like (0)

Report
Copy link

Link copied!

Cant believe I didn't see that. Thanks.

Was this reply helpful? Yes No