Unanswered

Filter Gallery based on choice column and multiple choice column

(0) Share

Report

Posted on by YamiteKudasai

195

Hi Everyone,

I would like to ask for help filtering gallery based on 1 choice column and 1 multiple choice column. Please refer to screenshot below.

I want to filter List based on these choice dropdown columns.

If I use method below. It is only 1 filter condition.

Filter(
 'List Name',
 Concat(ComboBox2.SelectedItems,Value&",") in
 Concat('Days of the Week',Value&",")
);
ForAll(
 ComboBox2.SelectedItems,
 Filter(
 'List Name',
 Value in 'Days of the Week'.Value
 )
 )

Kindly help the best way to filter gallery. Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

SpongYe 5,603 Super User 2025 Season 2 on at

Like (1)

Report
Hi @YamiteKudasai

You can use a With() function to filter first the department and then th e day of the ride:

With( { _itemsDeparment: Filter( 'List Name', ID = ComboBox.Selected.DepartmentID ) }, Filter( _itemsDeparment, Concat(ComboBox2.SelectedItems,Value&",") in Concat('Days of the Week',Value&",") ) )

Please adust the code to your needs but this is how you can combine both filters.

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube| [My blog]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
YamiteKudasai 195 on at

Like (1)

Report

Thanks @SpongYe , With works!

Was this reply helpful? Yes No
SpongYe 5,603 Super User 2025 Season 2 on at

Like (0)

Report

Hi @YamiteKudasai

Nice good to hear. Good luck further!

Was this reply helpful? Yes No