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.
Solved! Go to Solution.
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.
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.
Makes sense. Thanks!
User | Count |
---|---|
256 | |
106 | |
92 | |
47 | |
37 |