Announcements
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
Hi @Anonymous ,
Two ways: field1 &" "& field2 or Concatenate(field1," ",field2)
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?
Prakash
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.
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 505
WarrenBelz 502 Most Valuable Professional
Haque 324