🔍 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