cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frankie70
Post Patron
Post Patron

Checkbox as search refiners

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.

Frankie70_0-1618393534228.png

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.

1 ACCEPTED SOLUTION

Accepted Solutions

@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

View solution in original post

6 REPLIES 6
PatilChetan
Resolver I
Resolver I

@Frankie70 ,

 

Try below code 

 

App - Saved (Unpublished) - Power Apps and 6 more pages - Profile 1 - Microsoft​ Edge 4_14_2021 5_30_16 PM.png

 

App - Saved (Unpublished) - Power Apps and 6 more pages - Profile 1 - Microsoft​ Edge 4_14_2021 5_30_55 PM.png

 

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
Super User
Super User

Hi @Frankie70 ,

You could try this too

I've created similar data as yours

Ethan_R_0-1618403167755.png

Ethan_R_1-1618403180556.png

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

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.

@Frankie70 

 

Try below code

 

Screenshot (235).png

 

Screenshot (236).png

 

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.

Hi @PatilChetan ,

 

thanks for your reply.

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

@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

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (1,303)