cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kosenurm
Super User
Super User

Urgent - Combo box - concat/join another field value

Hi,

 

I have a Canvas App whereby I am using a combobox which has Items of 

 

Sort(AddColumns('DV_Table_Name',
           "ModifiedOnFormatted",
           Text('Modified On', "dd-mm-yyyy")),
           'Modified On', Descending)

 

and DisplayFields of

 

["new_companyname","ModifiedOnFormatted"]

 

This creates the combobox with the name of the Company first, and the ModifiedOn date next.

 

What I want is to add another column's value to the "end" of "new_companyname" - this other column's value is a reference number. How can I do this so that, in the combobox, it would display    

 

Company Name   /    Reference Number

ModifiedOn date

 

for each?

 

Many thanks, 

K.

1 ACCEPTED SOLUTION

Accepted Solutions
AaronKnox
Resolver IV
Resolver IV

I was thinking we would need another AddColumns but does this work?  (Change reference_number to your column name)

Sort(AddColumns('DV_Table_Name',
           "ModifiedOnFormatted",
            Text('Modified On', "dd-mm-yyyy"),
           "ModifiedNewCompanyName",
           new_companyname & " / " & reference_number),
'Modified On', Descending)

Then change display fields to 

["ModifiedNewCompanyName","ModifiedOnFormatted"]

   

View solution in original post

1 REPLY 1
AaronKnox
Resolver IV
Resolver IV

I was thinking we would need another AddColumns but does this work?  (Change reference_number to your column name)

Sort(AddColumns('DV_Table_Name',
           "ModifiedOnFormatted",
            Text('Modified On', "dd-mm-yyyy"),
           "ModifiedNewCompanyName",
           new_companyname & " / " & reference_number),
'Modified On', Descending)

Then change display fields to 

["ModifiedNewCompanyName","ModifiedOnFormatted"]

   

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,119)