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.
Solved! Go to Solution.
"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
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.
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
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.
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.
Hi @PatilChetan ,
thanks for your reply.
I do not understand the "Devicea"-part. I am a bit lost here 🤔
"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
User | Count |
---|---|
258 | |
109 | |
93 | |
57 | |
41 |