Collection AddColumn - Reference another column

[BradLambie]

Hi,

I am trying to add a new column to a collection I have created.

Below you can see how I create the collection from TextInput1

ClearCollect(shutter_panels,Split(TextInput1.Text,"T"));
AddColumns(shutter_panels,"qty_panels",Len(Text(Result)));

 Creating the collection works fine however the add columns is doing nothing and throwing no error.

Test input TextInput1.Text = LTLRTR

However I get no additional column counting the length of the string in the first column. Any ideas?

Below is the output

Collection

[BradLambie · Accepted solution]

Yeah ok, was pretty silly/rushing. AddColumns does not work with collections. I had to hold it as a table then add the column whilst creating the collection.

ClearCollect(shutter_panels,AddColumns(Split(TextInput1.Text,"T"),"qty_panels",Len(Text(Result))));

Correct output