Delete column from collection

(0) Share

Report

Posted on by roby9390

105

I have a gallery with checkbox, oncheck the app collect the items from the gallery in a collection named colBooking.

In my gallery, with the AddColumn function, I added a column "SEARCHID" for searching the ID in a textbox.

My current problem is that for the purpose of the colBooking collection I need it not to collect the "SearchID" column.

Do you have any ideas on how to fix it?

I also tried to collect the columns individually like this:

Collect(colBooking;ThisItem.column1;ThisItem.column2;ThisItem.column3)

but I don't know what to add to the OnUncheck property to remove the record if the user unchecks the checkbox.

I hope I explained myself better. If so, I'm available for other explanations.

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

DavidZoon 738 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

You can use formula DropColumns() in your collect(), in the same way you used AddColumns() in your gallery source , it'll make the schema of your column liket before you added the column SEARCHID

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily.
roby9390 105 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @DavidZoon and thanks for your reply.
I had already tried it but it's not clear to me where to put the dropcolumn function.

Now the OnCheck property of my checkbox is as follow:
Collect(colBooking;ThisItem)
How should I change it?

thank you for your support
DavidZoon 738 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Logically, if the column is added in the Items of the gallery, you will have to drop the added column when you are going to request the data in this same gallery.
The following syntax should work:

Collect(colBooking;DropColumns(ThisItem,"IDSEARCH"))

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily.
roby9390 105 on at

Like
a
(0)

Report
Copy link

Link copied!

If I use the syntax you indicated near "ThisItem" I get an error: "The type of argument is not valid (record): a table value is expected."

How can I solve it?
DavidZoon 738 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

My bad, DropColmuns don't work with column, you have to convert it to table and get de first item when colmun is dropped :

Collect(colBooking;First(DropColumns(Table(ThisItem),"IDSEARCH"))