I'm creating an app for checking out assets. Currently items are added to a collection before it is checked out. What I can't figure out is how to remove items that are added to the cart (collection) but not checked out yet (that is, patched to the source). I'm using the following filter on the gallery:
Filter(ds; StartsWith(Title; searchField.Text) && InService = 1 && CheckedOut = 0)
I've been thinking of filtering ds on the basis of the cart collection, but can't quite connect the dots. My source (ds) is a sharepoint list.
Do you want to only show remained items from the SharePoint list to a gallery after others have been added to a collection?
Please take the following scenario for a reference.
Frist, create a connection to SharePoint List 11.
On the gallery screen, add a search box, and set Screen.OnVisible with the following code:
Then add a Gallery and set its Items property with this code which will only show items that are not in the collection:
Filter(List11,Not(Title in testlist11collection.NewTitle))
A screenshot for your reference: