Combine Table for ComboBox

[Anonymous]

Hi All, 

I have problem Combine 2 table as List in combo box, what i want is to add Pcode1 itemlist and Pcode2 item list to one Combobox, can anyone help me? thanks

[WarrenBelz]

Hi @Anonymous ,

Do this

ClearCollect(
   colItems,
   ShowColumns(
      AddColumns(
         PCode1,
         "New",
         'Project Code'
      ),
      "New"
   ),
   ShowColumns(
      AddColumns(
         PCode2,
         "New",
         'Project Code'
      ),
      "New"
   )
)

then the Items of the combo box will be colItems

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.

[Anonymous]

hi @WarrenBelz  i try code what u give but i get this error notif

[WarrenBelz · Accepted solution]

Hi @Anonymous ,

That is not the Items of the combo box - you need to run that code off a trigger (screen OnVisible will do) and then the Items of the drop-down will be colItems

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.

[Anonymous]

hi @WarrenBelz  its work but what i want not like this

what i want out put in combo box is List Joint Betwen PCode1 and PCode2, not combine betwen PCode1 and PCode2

[Anonymous]

Hi @WarrenBelz  thanks for your help done with little modif ClearCollect(colItems,AddColumns(PCode1,"New",'Project Code'),AddColumns(PCode1,"New",'Project Code')

[WarrenBelz]

@Anonymous ,

Not something easily done, but I have a blog on the process that may assist.