Checkbox all based on text filter

[Skamstrup]

Hi community

Thanks for all of your help and inputs. I have come across a new issue and I hope one of you can help me out here. I have created a gallery showing all my products and a search filter to filter the gallery based on the product name. Furthermore, I have created a checkbox for selecting all checkboxes due to some cases I want to bulk update. However, if i search for a product (i.e., a charger) and I select the select all button it selects ALL my products not only the ones I have searched for. Does any one know how to proceed further with this? (see attached picture) 🙂

Kind regards

[Drrickryp]

@Skamstrup 

It depends on how your  "checkboxfor selecting all checkboxes"  works.  It should work on the filtered dataset that is the result of your Search(), rather than the whole dataset.

[Skamstrup]

Thanks for your answer. I am however having trouble writing this into the code.

[Ethan_R]

Hi @Skamstrup ,

With basic scenario if you are linking the checkbox to your datasource record.

UpdateIf(
   Filter(
      PRODUCTS, 
      IsBlank(TextInput.Text) || 
      Type = TextInput.Text
   ), 
   true, 
   {Tick: true}
)

So first,

Then filtering records and patching

Remove filter and see outcome

Now,

Let's say if you are not linking the field to anything from datasource,

Then use Collection,

So when you Select the outer Checkbox, OnCheck formula will trigger a store all filtered data into collection (Note: You should have a unique identifier)

You gallery Checkbox that is unlinked to any field. you should link as If that record is present in the collection, show as checked else unchecked.

Later, perform operation on Collection and once completed. Clear collection.

Hope this helps

[Skamstrup]

Thanks it helped. But sorry if I am a little slow - should the code you are writing go into the gallery checkbox or the select one?

[Skamstrup]

Hi again @Ethan_R 

Thank you again for your response.

I got really close with the following code:

ClearCollect(colSelected, Filter(colGridData, IsBlank(searchProduct.Text) || 'Product Name' in searchProduct.Text)); ForAll(galGrid.AllItems As Item, If(Item.chkBox.Value, Collect(colSelected, {chkBox: true, 'Product Name': Item.'Product Name'})))

However, this only select the products which have the exact name in the searchfield. Do you know if it is possible to select the products that contains some of the name (i.e., is visible). For instance if you write Char and not Charger

[Ethan_R]

Hi @Skamstrup ,

You have to write the following code on the Checkbox that is residing outside the Gallery (To select all filtered)
Please assign code in property of Control from the code

//For Gallery -> 'Items' property
Filter(
  colGridData, 
  IsBlank(searchProduct.Text) || 'Product Name' in searchProduct.Text
);

//For Checkbox that is outside Gallery to select all Filtered records
ClearCollect(
    colSelected,
    ShowColumns(
        Gallery.AllItems,
        "ID",
        "Name"
    )
);

//For Checkbox that is inside the Gallery -> 'Default' property
If(ThisItem.ID in colSelected.ID, true, false)

Note: ShowColumns is used to minimize bulk data into collection, keeping required data.

So, ID is unique identifier of the records and Name is just record Name (optional)

Hope this helps