Concatenating to Columns within a collection

[ToFj]

Hello Everyone, 

I have some excel data that I would like to concatenate and then populate a dropdown menu. I have been trying it with the following code, but my new column shows up empty. 

ClearCollect(Collection, Table1);
Collect(Collection,{NewColumn: Concatenate(Collection.ID," - ", Collection.Title)})

And when I try to populate the dropdown menu i get the following warning

Do any of you have any tips? 

Would certainly be greatly appreciated. 

[gabibalaban · Accepted solution]

Hi @ToFj ,

Are you trying to add a new column to your collection ? If so, please use this formula:

ClearCollect(Collection,
             AddColumns(Table1,"NewColumn", ID & " - " &Title)
            )

Now the collection is ready to be used inside items dropdown.  Don't forget to set value property on the right menu.

Hope it helps!

[ToFj]

Thank you very much @gabibalaban, worked perfectly.