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.


Report
All responses (
Answers (