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

I have the same question (0)

All responses (7)

Answers (1)

TheRobRush 11,128 Moderator on at

Like (0)

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

put that in dropdown items

Was this reply helpful? Yes No
vffdd 1,257 Super User 2024 Season 1 on at

Like (0)

Report

No gives me 2 errors. Forall has invalid arguments and filter has invalid arguments

Was this reply helpful? Yes No
vffdd 1,257 Super User 2024 Season 1 on at

Like (0)

Report
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

Was this reply helpful? Yes No
vffdd 1,257 Super User 2024 Season 1 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

TheRobRush 11,128 Moderator on at

Like (0)

Report
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)

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (1)

Report

Yes, this will also work, but don't forget to write the code for the onuncheck as well

Was this reply helpful? Yes No
vffdd 1,257 Super User 2024 Season 1 on at

Like (0)

Report

Yes did forget that LOL thanks

Was this reply helpful? Yes No