Unanswered

How to Concatenate 2 fields in Power Apps

(0) Share

Report

Posted on 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:

Building Power Apps

I have the same question (1)

All responses (4)

Answers (1)

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report

Hi @Anonymous ,

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

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

Like (1)

Report

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

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

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,032 Most Valuable Professional on at

Like (5)

Report
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.

Was this reply helpful? Yes No