I need to join the first name and last name of two variables

(0) Share

Report

Posted on by RodrigoSifon

Hi everyone!

I am stuck with the following problem in RED

the "Patricia Andrea" is this variable:

and "Valdeavellano" the father's last name is:

I want to join the first name (before the space between the first and middle names) with the paternal last name
I want to place only "Patricia Valdeavellano" in a text box for all cases
what is the correct formula to use?

I've searched everywhere and can't find a solution.

Thanks,

Rodrigo
From Chile !

Categories:

Building Power Apps

All responses (15)

Answers (1)

Sort by

Ethan_009 4,840 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @RodrigoSifon ,

You need to do this:
ThisItem.Nombres & " " & "ThisItem.ApellidoPaterno"

Hope this helps
RodrigoSifon 75 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you very much for your quick response, I did what you wrote me
but the second name still appears

I want only for expample
"Patricia Valdeavellano" instead "Patricia Andrea Valdeavellano"

I want to eliminate Andrea
HectorOlivos 411 on at

Like
a
(0)

Report
Copy link

Link copied!
Hola Rodrigo:

Puedes usar este codigo:

Concatenate( Left(ThisItem.Nombres, Find(" ", ThisItem.Nombres)-1), " ", ThisItem.ApellidoPaterno )
RodrigoSifon 75 on at

Like
a
(0)

Report
Copy link

Link copied!

Hola muchas gracias!
pero no se que error hay que no me da la formula
HectorOlivos 411 on at

Like
a
(0)

Report
Copy link

Link copied!

Que items tienes en tu galeria?
Ethan_009 4,840 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @RodrigoSifon ,

This helps?
Left(ThisItem.Nombres, IndexOf(ThisItem.Nombres, " ")) & " " & ThisItem.ApellidoPaterno
RodrigoSifon 75 on at

Like
a
(0)

Report
Copy link

Link copied!
RodrigoSifon 75 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Ethan,
I really appreciate that you are helping me,
Something happens that after putting the comma it doesn't let me put "Indexon" or anything else, for example a find...
Verified answer

HectorOlivos 411 on at

Like
a
(0)

Report
Copy link

Link copied!
ya vi el error

prueba con esta:

Concatenate( Left(ThisItem.Nombres; Find(" "; ThisItem.Nombres)-1); " "; ThisItem.ApellidoPaterno )
Ethan_009 4,840 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @RodrigoSifon ,

I think your PowerApp is following ";" instead of ","
Do replace all commas with semi-colon

Just PowerApps things 🙂