Power Platform Community Forum Thread Details

I'm trying to figure out how to format this filter. I have a collection of data in a gallery. When a user selects an item, it gets copied into a second collection. How do I filter the first collection so that the items in the second collection are no longer shown. Here is the filter as it stands, All of the other filters need to be available too. The way I've formatted it gives me the comparison error: Table,Text. To the user, this should look to the user like the item is moving from one gallery to another.

GroupBy(Filter(colFirstCollection,
(TextInputCanvas1_2.Value in KEY Or IsBlank(TextInputCanvas1_2.Value)),
(txtHRMNIDsearch_1.Value in EMPID Or IsBlank(txtHRMNIDsearch_1.Value)),
(If(CheckboxCanvas1_7.Checked,Covering=true,Covering=true Or Covering=false)),
(txtEmailSearch_1.Value in EmailID Or IsBlank(txtEmailSearch_1.Value)),
(colSecondCollection.KEY<>KEY)// this is where I tried excluding all of the KEY items in the second collection
),KEY,UserDetail)

Categories:

General Questions

Hi MV-30041934-0

See bottom line of filter - some other suggestions in there as well

GroupBy(
   Filter(
      colFirstCollection,
      TextInputCanvas1_2.Value in KEY Or Len(TextInputCanvas1_2.Value) = 0,
      txtHRMNIDsearch_1.Value in EMPID Or Len(txtHRMNIDsearch_1.Value) = 0,
      CheckboxCanvas1_7.Checked && Covering Or !Covering Or !CheckboxCanvas1_7.Checked,
      txtEmailSearch_1.Value in EmailID Or Len(txtEmailSearch_1.Value) = 0,
      !(KEY in colSecondCollection.KEY)
   ),
   KEY,
   UserDetail
)

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee