You’re offline. This is a read only version of the page.
802
Hi,
I have a Canvas App whereby I am using a combobox which has Items of
Share
ReportSort(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.
I was thinking we would need another AddColumns but does this work? (Change reference_number to your column name)
All responses (
Answers (
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"]
