Filter a gallery with checkboxes

(0) Share

Report

Posted on by Hii_iii

691

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

QuentinDURIEZ 577 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi,

If I assume that the field "Nature" is a Choice column in your Dataverse table, I suggest you to use RadioGroup instead of multiples Checkboxes, where Items are simply :
Choices([NATURE OPTION SET])
This formula will retrieve all possible options for your Choice column defined in Dataverse and will avoid having multiples checkboxes in your app that will do the same thing.

After this, in the Items property of your gallery, use this :

Filter([SOURCE] , IsBlank([RADIO_COMP].Selected ) Or [NATURE FIELD] = [RADIO_COMP].Selected.Value)

Regards,

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report
Copy link

Link copied!

.

Was this reply helpful? Yes No
QuentinDURIEZ 577 Moderator on at

Like (0)

Report
Copy link

Link copied!
Ok, so instead of using Choices(), create a collection or a table with all possible values (but a choice column will be more suitable!)

RadioGroup Items :
Table(["Option1", "Option2"])
The Filter will be exactly the same.

The main idea is to avoid creating distinct componements which have the same behavior and simplify the logic

Regards,

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report
Copy link

Link copied!

.

Was this reply helpful? Yes No
QuentinDURIEZ 577 Moderator on at

Like (0)

Report
Copy link

Link copied!

That's why I suggest you to use radio button instead of checkboxes

Checkbox are meant to be like a switch toggle, radiogroup offer a more likely to works like a combobox

In the future, if a 3rd value if Nature need to be implemented, you will save times

https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/controls/control-radio

Regards,

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report
Copy link

Link copied!

.

Was this reply helpful? Yes No