How to Concatenate 2 fields in Power Apps

Like (0) Share

Report

Posted on 2 Dec 2020 15:24:36 by Community Power Pla...

Hi All,

I have two field in power apps pulling it from Sharepoint list.

Now i want another column by concatenating those 2 fields for eg., First name concatenated with Second Name so that i can name the third field as "Full Name" and display that information. How to Concatenate those 2 fields?

Thanks in Advance

Regards,

Prakash M

Categories:

General Questions

All responses (4)

Answers (1)

Verified answer

WarrenBelz 149,102 Most Valuable Professional on 05 Dec 2020 at 22:51:13

Like (5)

Report
Re: How to Concatenate 2 fields in Power Apps

Hi @Anonymous ,

Expanding on @Drrickryp's post, you could do it with a Collection - you could do this at Screen OnVisible

ClearCollect( colDD, AddColumns( YourListName, "FullName", 'First Name' & " " & 'Second Name' ) )

The Items of your drop-down would be

colDD.FullName

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Community Power Pla... on 04 Dec 2020 at 08:01:25

Like (0)

Report

Re: How to Concatenate 2 fields in Power Apps

Hi @Drrickryp ,

In Edit form I added 2 fields in Dropdown. First Name and Second Name.
But I would like to create a field as Full Name = First Name concatenate Second Name and that i would like to put in Dropdown.
So instead of 2 dropdown i am trying to give name in Single drop down.
How to concatenate 2 existing fields in edit form?

Here in the below blog i bought the fields into dropdown and now i am trying to concatenate 2 fields in edit form.
https://powerusers.microsoft.com/t5/Building-Power-Apps/How-to-change-Text-box-to-Combo-Box-Dropdown/m-p/760855#M242518

Please help me to concatenate 2 existing fields in Edit form.

Regards,
Prakash
Community Power Pla... on 02 Dec 2020 at 16:21:19

Like (1)

Report

Re: How to Concatenate 2 fields in Power Apps

Hi @Drrickryp ,

Thanks for your reply.
But unfortunately i am confused on where to give this formula or where to create the 3rd column.

In Power BI we will have option like "Create Column" but i dont see such option here.

Where i need to give this formula?

Regards,
Prakash
Drrickryp Super User 2024 Season 1 on 02 Dec 2020 at 15:44:32

Like (1)

Report

Re: How to Concatenate 2 fields in Power Apps

Hi @Anonymous ,

Two ways: field1 &" "& field2 or Concatenate(field1," ",field2)