Unanswered

Filter conditionals but omit when no selection

(1) Share

Report

Posted on by jimi_hendrix

So in short, I have some number of combo boxes.. some are multiselect some are single select.. These selections then filter out content in a gallery. My question is how do you omit a combo box, when there isnt a selection to filter against??

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

365-Assist 2,324 Moderator on at

Like (0)

Report
Copy link

Link copied!
Firstly you need to count the records in the source of your Combo Box Items. In my example I have the source as a Collection. I used the CountRows function and then set a variable based on if blank rows or has rows
If( CountRows(colDropDown) = Blank(), Set (varVisibleDropDown,false), Set (varVisibleDropDown,true); )

Then in the Visible Property of the Combo Box set it to the variable.

---------------------------------------------------
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
Twitter: https://twitter.com/assist_365
Regards
Darren Lutchner - 365 Assist

Was this reply helpful? Yes No
jimi_hendrix on at

Like (0)

Report
Copy link

Link copied!

@365-Assist I think there is some confusion. Let me clarify.. Im not looking to hide the combobox..

I have a gallery with a list of records. Say I have a column for office, and a column for job title. And I have a combo box for office and a different combo box for job title. When I have selections in both job title and office, I want the dataset to be filtered.. BUT if someone only wanted to filter on office and NOT job title or vice versa, how would I go about making the Filter for the Gallery. I obviously need to call out both comboboxes selections so I can filter on them but when there arent any selections it doesnt work. Seems like I would need a conditional in there. Whatever solution, please help provide an example

Was this reply helpful? Yes No
365-Assist 2,324 Moderator on at

Like (0)

Report
Copy link

Link copied!

I found a few videos that may help guide you.
https://www.youtube.com/watch?v=bujH2gzTduQ
https://www.youtube.com/watch?v=Wr42PeW6_wU
https://www.youtube.com/watch?v=5dSk5iOgT68

---------------------------------------------------
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
Twitter: https://twitter.com/assist_365
Regards
Darren Lutchner - 365 Assist

Was this reply helpful? Yes No