cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BradLambie
Frequent Visitor

Collection AddColumn - Reference another column

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

 

CollectionCollection

 

1 ACCEPTED SOLUTION

Accepted Solutions
BradLambie
Frequent Visitor

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))));

Capture.PNGCorrect output

 

View solution in original post

1 REPLY 1
BradLambie
Frequent Visitor

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))));

Capture.PNGCorrect output

 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,896)