How to find items in one collection that dont exist in another collection

[RussellGove]

So I have a list of Items (called myItems)that come from SQL displayed in a gallery and I let users select items by checking a checkobox in the gallery template. The list has a primary key ID, When the item is selected , i collect it to a second collection called selectedItems.

Now i have buttons that let the users perform process on the selected or the unselected items. How do i get a list of unselected items (i.e. items that are in myItems but not in selectedItems).

I thouht this would be easy with a forAll statement so i started coding:

ForAll(myItems,If (LookUp(SelectedItems,ID=ID,true,false),Collect(unselecected,t.....

But then i realized that i cannont compare the ID of the selectedItem with the item from the forall loop because it doesnt give us a ThisItem object to work on.

Anyone have ideas how to do this?

[Tom_Slosse · Accepted solution]

Hey @RussellGove

Is there a boolean that you pass if something is checked or not, if so then you could collect the unchecked equals false ones (unselected items).

Kind regards

Tom

[Anonymous]

Thank you for taking the time to review and reply to this post @Tom_Slosse

@Anonymous