Multi Select CASCADING Combo Boxes in Power Apps | Step-by-Step Tutorial

In this step-by-step Power Apps tutorial video, we will learn how to build Multi Select CASCADING Combo Boxes. We will create 3-level cascading (dependent dropdown-like) controls in Power Apps.

What You'll Learn:
✅ Creating Cascading Combo Boxes: Learn the basics and advanced techniques to set up cascading combo boxes in Power Apps.
✅ Using Distinct & Choices Functions: Discover how to use these functions to retrieve unique values for your combo boxes.
✅ Multi-Select Options: Explore multi select cascading combo box options with Dataverse (delegable) and SharePoint as data sources.

#powerapps #powerplatform #sharepoint #dataverse

⬇️ Download Cascading Power App shown in video
➡️ The link will be in Community Tab for Channel Members (Silver Club 🥈 or Higher)

0:00 Introduction on how to build cascading controls in Power Apps
0:28 Cascading combo boxes with SharePoint Lists in PowerApps
2:46 Building cascading (dependent dropdowns) in Power Apps from multiple SharePoint lists
6:28 Cascading dropdowns with DISTINCT function
10:01 RESET Cascading controls
10:45 Power Apps Multi select cascading combo boxes with SharePoint Lists
14:34 Delegable Multi select cascading combo boxes with Dataverse Tables

[sibidi]

Every video on this channel is a back to back hit. Thank you very much for the treasures you share on this channel.

[mirzasadiquebaig]

Someone asked me about Responsive Dialogue and I shared your informative video.
We are very happy to have you, Every time we learn something new.
Jazakallah 👍

[monicalindin]

Thanks so much, Reza. This is so useful for the Rangers who work in our national parks. They'll be able to select locations based on areas to complete safety checklists for issues like fires, floods and other incidents. You make their work easier under challenging circumstances!!

[kausarjahan]

Hey Reza, I was really looking forward to your video last night, but it was members-only. So glad it's available for everyone now! Your content always brightens my day..!!

[muktirashmi]

You are amazing!

I highly recommend anyone who hasn't joined Reza's live training sessions to do so if they can. It's absolutely worth every penny!

[WillCooper]

Great topic Reza - good for you. People have always wanted to have cascading dropdown menus. I love your detailed explanations. Fantastic work.

[dougydoe]

Great Demo on cascading selections. Stored in my Reza Environment as I'm sure I might need it as a reference sometime soon 😁😄. Thanks again for sharing.

[spen]

Perfectly explained - Thanks for sharing 👍👍

[bernadettealvarado]

I always watch on my work laptop but I make sure to go on my personal laptop to hit like because Reza’s videos are always so helpful! I learn a lot from it.

[akshayjathar]

You are awesome Rezza. Thank you for this video😍😍😊😊

[TeslaZx]

Hi Reza,

Thank you for the amazing tutorials on Power Apps; they have been incredibly helpful!

I have a question regarding a combobox with multiple selections in Power Apps. I am struggling to set the DefaultSelectedItems property to retrieve the selected values stored in a SharePoint list. Could you please provide some guidance or a formula to achieve this?

Thank you so much for your help!

[VANDIK]

Great video Reza, quick question, how can I Patch those examples? thanks

[Lisannegadoua-uk]

Thank you Reza, always great demos, I was able to replicate it although I was not able to patch the sub drop down data back to SharePoint, appreciate if you could share how best to do this, thanks again.

[jameelkhawam]

Thanks so much for these videos, they are so helpful for me and explained really well. Is there a way in a dropdown/combobox to only list the values that appear in a SharePoint multiple choice column. So not show all the possible values/choices in a lookup field - only those that have been selected in the data.

[boqewwn]

Thank you very much Reza. When the multiselect option is not active and you want to deselect the selected option, it does not display 'Select items' again, but instead shows the last selected option.

[JoeAtWork-gywh]

Hi Reza, awesome video as always.
You have guided me so much since I started this journey 13 months ago as a middle-aged dude.

I built a small app recently with cascading combo-boxes for a training portal app.
The first combo box allows the admin to select a Document Library name from a list of items which then triggers a switch to different galleries for the admin to select multiple documents from and this also filters the next combo-box to employees in multiple mail enabled security groups where the admin can then select multiple employees to assign the training documents to.

However, one of the galleries is a general access document library so I made a collection of all the employees in the other security groups so the group is quite large.
Is there an easy way to select all items/employees (at once) in a modern multiselect combo-box or could you possibly point me in the right direction of how to achieve this?

I tried working with chatGPT but I have not found a solution to date.
Apologies for the long comment.

[Psrk]

A question regarding SharePoint managed metadata columns. Is there any control in PowerApps to show this.

[theoneisgod]

I was broswing for answer and in came upon your videos.

Question:
I have a SharePoint list and i want to use power automate to update the column choice itself. Example: I have a column called "Service Member" and using a choice type. I have 27 choices . What i want to do is use power automate to look at my excel sheet for updated names, delete the choice and re-add the new choice from my list. Is this possible? Any help would be great .

[seang]

Reza, this is a random YouTube question but I seem to recall awhile back you were talking about memberships and said YouTube is coming out with a TVOD pay per view option. Is that true? Do you have anymore details on it? Also are you able to set memberships as an annual yearly purchase? I’m looking at TVOD or memberships for a work YouTube channel.

[chandradeepwaghare]

hello sir, showing error, "cannot use table values in this context". when I use Category.Value. please suggest in this. (multi-select column).
suggest column type in which data stores.