Answered

Connect A Button to a Gallery to Filter

(0) Share

Report

Posted on by Morgan_W

Hello, I'm trying to set up buttons to filter a list in a gallery. The list is connected to a SharePoint List, and the column is a choice column. I'm very new to power apps, but I have On Select set up as:

Filter ('Cleaning-Checklist', Area. Value = "Sorter")

but it is not connecting to the list in the gallery.

When I put the filter into the items section in the gallery it works fine, but I want it to only filter when I click the button.

Here's what it looks like:

If you need more information, please let me know I cannot seem to figure this out. Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Rajkumar_M 3,747 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @Morgan_W

Set the OnSelect property of the button to the following formula:

UpdateContext({FilterValue: "Sorter"})

Modify the Items property of the gallery to include the filter condition:

Filter('Cleaning-Checklist', Area.Value = FilterValue)

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
Morgan_W 28 on at

Like (1)

Report
Copy link

Link copied!

Thank you so much!!! That worked perfectly.

Was this reply helpful? Yes No
AndrewR1 1,572 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @Morgan_W I would do something like the following:

So on the on select of your button to set a variable Like:
Set(SortVar,"Sorter")
(You would need to repeat this for each of your buttons)

The Set the Items Property of the Gallery to:
Filter('Cleaning-Checklist',SortVar = Area. Value)
Assuming that both values are text and not a choice field?

For my example I used a choice field and I replaced the = with in operator but this is the same concept:

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. Remember, you can accept more than one post as a solution. If the content was useful in other ways, please consider giving it Thumbs Up.

Thanks
Andrew

Was this reply helpful? Yes No