Urgent - Combo box - concat/join another field value

(0) Share

Report

Posted on by Kosenurm

802

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,

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

AaronKnox 514 Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!
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"]

Was this reply helpful? Yes No