Populate dropdown based on checkbox in a gallery

(0) Share

Report

Posted on by vffdd

1,257 Super User 2024 Season 1

I have a gallery with 2 checkboxes CheckBoxYes and CheckboxNo and one label Thisitem.LineItem

I would like to filter a dropdown to show only those items in the gallery where the check box CheckBoxNo has been checked.

I'm using this.. But it shows all of the items in the gallery not just the ones where checkboxNo is checked.

Filter(
 Gallery1.AllItems,
 CheckboxNo.Value = true
).LineItem

Any suggestions?

TIA

Categories:

Building Power Apps

All responses (7)

Answers (1)

Sort by

TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Filter(ForAll(Gallery1.AllItems As theList, If(theList.CheckboxNo.Value=true,theList.LineItem)),Value)

put that in dropdown items
vffdd 1,257 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

No gives me 2 errors. Forall has invalid arguments and filter has invalid arguments
vffdd 1,257 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
ok I think I know what the issue is with your syntax. The checkbox is not part of the items in the gallery it's just a check box added in so when I get to the

(theList.CheckboxNo.Value

part of your code there is no option to put .Checkbox.value
vffdd 1,257 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

ok I've done it a different way! I've created a collection when I check the no box and then put the collection as the items in the dropdown ! that seems to work
Verified answer

TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Yah my checkboxes are in the gallery but NOT tited to the items of the gallery so default just set to false like so

and then my dropdown is populating the two selected

where my items property is

Filter( ForAll( //Gallery Name Gallery8.AllItems As theList, //Check Checkbox If(theList.Checkbox3.Value=true, //Which COlumn I want to go on my dropdown theList.WorkOrder)), ///final portion, returns value of above Value)
TheRobRush 11,128 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Yes, this will also work, but don't forget to write the code for the onuncheck as well
vffdd 1,257 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes did forget that LOL thanks