Checkbox as search refiners

[Frankie70]

Hi all,

I have a SharePoint List with products (4 categories: Laptop, Mobile, Conferencing, Periphery).

I would like to use 4 checkboxes to filter a gallery. Per default, all checkboxes are checked (all items of the 4 catergories are shown in the gallery).

By unchecking a checkbox, the gallery should not contain items of the unchecked catergory.

The user should be able to search and refine the search results.

I am really stuck here and really need some help.

I appreciate any ideas.

[PatilChetan]

@Frankie70 ,

Try below code 

Regards,

Chetan

Please click Accept as solution 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 Thumbs Up.

[Ethan_R]

Hi @Frankie70 ,

You could try this too

I've created similar data as yours

So here for items property for Gallery (Devices is my data source) Add more as your case

Filter(
Devices,
If(
Checkbox1.Value,
Category = "Laptop"
) || If(
Checkbox1_1.Value,
Category = "Mobile Device"
)
)

Hope this helps

[Frankie70]

Hi @PatilChetan 

it works perfectly.

But I would like to include the seach bar aswell.

So, search in the search ba and use refiners to refine the seach results.

Or filter first and then search with the search bar.

[PatilChetan]

@Frankie70 

Try below code

Regards,

Chetan

Please click Accept as solution 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 Thumbs Up.

[Frankie70]

Hi @PatilChetan ,

thanks for your reply.

I do not understand the "Devicea"-part. I am a bit lost here 🤔

[PatilChetan · Accepted solution]

@Frankie70 ,

"Devicea" it's typo error, it is column name in Machines table.

Refer the link for more details about Search formula: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup#syntax 

Regards,

Chetan