DropColumns from collection with retrieved data from a list

[theisogunro]

I have a SharePoint list that I add to a collection in my PowerApps.  Unfortunately, there are about 15 columns that I don't need.  I tried using DropColumns() to remove unneeded columns but that didn't seem to do anything.  Here's what I added in my OnStart:

ClearCollect(salesCollection, Sales);
DropColumns(salesCollection,"Author");

When I look at my collection, Author still exists.

[RandyHayes · Accepted solution]

@theisogunro 

DropColumns is a function that returns a table of records with the column dropped.  You are not applying the output of the function to anything.  It does not alter an existing table.

Your formula should be:

ClearCollect(salesCollection, DropColumns(Sales,"Author"));

I hope this is helpful for you.

[theisogunro]

Makes sense. Thanks!