Power Apps Tutorial: Multi-Select Combo Box Gallery Filter [Step-by-Step Guide]

🔍 Have you ever struggled to filter a gallery based on a multi-select column in your data source? You're not alone! In this video, we tackle a common challenge faced by Power Apps users: filtering a gallery with a multi-select choice column in SharePoint.
➡️ Get access to our free Power Apps crash course (and our community) here: go.superpowerlabs.co/superlan...
-Darren Neese with PowerApps Tutorial
🎓 A student came to me with this exact problem, and I took it on as a challenge. While I typically advise against using complex types like choice columns in SharePoint, sometimes you need to work with what you have. In this tutorial, I'll guide you through the process step-by-step.
📋 What You'll Learn:
========================
➡️ The pitfalls of using multi-select choice columns in SharePoint.
➡️ How to set up your SharePoint list for multi-select filtering.
➡️ Implementing a combo box for multi-select filtering in Power Apps.
➡️ Using the Concat function to handle multiple selections.
➡️ Overcoming delegation issues with the in operator and semicolon separation.
🔧 Watch as I demonstrate how to create a dynamic gallery filter based on multi-select choices, ensuring your app can handle many-to-many relationships effectively. Whether you're working with a simple list or dealing with more complex data structures, this video has got you covered.
👩‍💻 By the end of this video, you'll have a clear understanding of how to manage multi-select filtering in Power Apps, making your apps more powerful and user-friendly.
📢 Don't forget to like, share, and subscribe for more Power Apps tips and tutorials. If you have any questions or need further assistance, drop a comment below!
00:00 - Introduction
00:25 - Data Source and Project Setup
01:05 - Gallery and Data Source
01:58 - SharePoint List Setup
02:38 - One to Many Relationship
03:14 - Many to Many Relationship
03:56 - Associating Records with Choices
04:07 - Filtering a Gallery
04:35 - Dropdown List and Filtering
05:02 - Filtering the Data Source
05:47 - Delegation Warning
06:20 - Handling Delegation Issues
07:26 - Limitations of the Filtering Approach
07:50 - Multi-Select Filtering Requirement
08:07 - Demonstrating Multi-Select Filtering
08:42 - Column for Filtering
09:27 - Comparing Multiple Items
09:52 - Final Reveal
11:26 - Using Distinct Function
12:06 - Adding Additional Columns
12:38 - Filtering with Added Columns
12:54 - Analyzing Matches
13:25 - Final Demonstration
#PowerAppsTutorial
#PowerApps #SharePoint #GalleryFilter #MultiSelect #DataFiltering #Microsoft #LowCode #NoCode #PowerPlatform #Tutorial

[@kennethgottfredsen767]

Darren is the man!

[@AReallyBadFish]

Great stuff. Thanks!

[@PowerAppsTutorial]

Thank you for watching! :)

[@davidclay717]

Fantastic, EXACTLY what the Dr ordered! Question: Where and what would you enter in the filter to show all records if nothing was chosen in the combobox?

[@PowerAppsTutorial]

Add an OR operator in your Filter (2nd parameter).
" Or IsEmpty(comboBox.SelectedItems)"

[@davidclay717]

Thanks Darren

[@MichaelDeBlasis1369]

Wow very cool

[@PowerAppsTutorial]

You welcome! Get more on my FREE community here: www.skool.com/power-apps-community🍬

[@MichaelDeBlasis1369]

@@PowerAppsTutorial I was reading that you're a relationships expert. For sharepoint lists being used primarily by power apps, do you reccommend using single text columns over lookup columns for simplicity? And if so do you have any videos on that? Creating list associations with signle text column. I guess it would need a ID column too? LOL so lost on this stuff as I'm new to it all.

[@ResponsibleXI]

But AddColumns functions is still not delegable right?

[@PowerAppsTutorial]

Oh yeah. You're still going to have delegation problems. Which is why I tell people never use choice or any other complex types.
ruclips.net/video/5mHjbzQefcw/видео.htmlsi=W0gTa6nx3gIxwUsd