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
Responsive Resident
Responsive Resident

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

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

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