Multi Select Filters in Power Apps with Combo box, Checkboxes & No Delegation❗

In this step-by-step tutorial video, we will learn how to build multi select filters in Power Apps. We will apply multiple filters to PowerApps Gallery including multiple item selections using combo box, multi-select checkboxes and multi select buttons.
We will build these gallery filters keeping delegation in mind (No delegation warning) & work with multiple data sources like Dataverse & SharePoint.
I will showcase how to filter a multi select choice column based on a multi select combo box control.
Trick is to go around the IN non-delegable Operator and use Equals (=) which is a delegable function.
I will also cover a new function called "Index" in Power Apps.

Video covers the following:
✅ Multiple Item Selection based Filters
✅ Combo box control to filter Gallery for SharePoint List & Dataverse
✅ Multi select checkbox-based filtering
✅ Multi select button-based Gallery Filter
✅ Multi Select Filter on Multi Select Choice Column
✅ Reset filters
✅ Delegation Workaround
✅ Index function

Power Apps Delegation Playlist:

PowerApps Multiple Filters on Gallery:

Power Apps Gallery Designs (Styling as Cards & more):

#PowerApps #Filter #PowerPlatform #SharePoint #Dataverse

Table of Contents:
00:00 - Intro
00:36 - Multi-Select Filter for Gallery
01:49 - Multiple Select Filters using Combo Box for Gallery connected to Dataverse
06:04 - Multi Select Filter using Combo Box on SharePoint List
10:58 - Create Multi Select Filters with Checkboxes
14:32 - Create Multi-Select Filter with Buttons
20:18 - Multi Select Filter on Multi Select Choice Column
23:33 - Subscribe to Reza Dorrani Channel

🤝 Let’s connect on social:

Wow, well that escalated quickly. It always looks simple and easy when demoed by Reza. Kudos for making this content. ❤

[karolpieta]

Finally I found solution for my case! Thank you! For me applicable was the part "Multi Select Filter using Combo Box on SharePoint List", but with one remark. I could not use the function Index, because no results where returned. But it works fine with Last(FirstN( alternative solution. Thank you once again!

[nicolaselder]

Thank you so much Reza! I was hitting a wall when I had to change a single choice combo box to multi choice and you saved my staff directory app. Such a godsend.

[ResponsibleXI]

Much needed one. Entire community is going to jump on this video 😀

[Bekesam]

I really liked how you used a gallery for buttons. It makes everything look uniform. I look forward to applying these techniques, so thank you!

[MissEmiy]

Life saver ! I searched everywhere to figure out how to compare tables to each other and this gave me the solution. Thanks :)

[ondrejtomiska]

You are my go to when i am struggling with something inPowerApps. Very clear explanations, thank you.

[oluwatobiyusuf]

Thanks for this great video. I picked up some more knowledge nonworking around delegations

[AshishJaiswal-brwo]

Bahut hard... Your You tube videos always shows god mode thinking 💭! 😃...

[robi]

thank you very much. The last minutes were perfect for what I had to do :)

[mauroquinteros]

Incredible as always Reza, thank you very much, It's sad but understandable that there are almost cero example on SQL databases, mostly dataverse and sharepoint, but work perfect for mine sql one!, except I still have delegation problem!

[WZY]

Thanks Reza. Your videos saved hours of my research time.

[god_hacker]

Great video as usual. I love to learn from your videos. Always well presented.

[sujisam]

Wow...great video as usual 😀..Thank you Reza!

[CloudhoundCoUk]

A stunning & impressive presentation. 🤩🤟Really, really good.

[juandavila]

Thank you for your videos, special about dataverse, they are amazing and useful. Thanks

[Brad-]

Hi, thanks for the great videos. I also had the error related to the Index exceeding the lower/upper bounds of my selected items but I was able to overcome the error by adding the IfError command and passing "False" if there was an error. e.g. IfError(Progress.Value = Index(ComboBoxProgress.SelectedItems, 1).Value, false)

[davidChannel]

Hi Reza, another great video. If you were trying to remove a specific selection from a multi-select combo box via a button press, what syntax would you use?

[coelhow]

Thank you Reza, it helped me tremendously.

[GhamNaKer]

Excellent content! Much needed functionality for many document management scenarios. Do you have a step by step detail guide for this video for beginners?