Drop Columns from single record

[hnguy71]

Hi All.

I have an icon and on it's OnSelect property I create a variable called _ParentItem that collects entire record of that item inside a gallery:

Set(_ParentItem, ThisItem);

I then have an icon that patches to a collection but there are a few columns that I don't have and I want to drop the columns but it's not allowing me:


How can I drop columns / fields from a record?

[Drrickryp · Accepted solution]

Hi @hnguy71 

You would use the DropColumns() function to do that when you create the variable.  Please see https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-table-shaping

[hnguy71]

Ahh drop them while I create the variable. Got it! I'll try that!

[pwagma]

I am stuck with this issue. When I  create the variable, I take it from a selected item of a gallery, so it doesn't let me drop the column at this moment

Any idea? I need to keep the variable as a single record