Power Apps: Cascade Drop Down List (Using Distinct)

[@PowerAppsTutorial]

❗ At the 10:08 mark, the code should rather be this: Sort( Filter( tblJobTypes, JobTypeText = ddlSalesEdit_JobType.SelectedText.Value ), JobSubType )

[@atxvet]

Perfect tutorial! I love the “code with me” style and no unnecessary fluff. Really well done!

[@PowerAppsTutorial]

Thanks so much! 😄👍

[@OB-HCP4]

This content is valuable. Thank you. Is there a way to get distinct values for two columns?

[@ChauNguyen-mg1oc]

Hi Darren, Thanks very much for the tutorial. Almost at the end of this video, I found one issue with the last drop-down of Job Sub Type. In the Filter function, JobTypeText should be used in a conditional statement instead of JobSubType, and JobSubType should use in the Distinct function. Thank you, Vu

[@PowerAppsTutorial]

Very good catch. I caught it later on after I published the video. But thanks for bringing it up in here in the comments. 😀👍 ...I wish I could add to the video after it's been published. 😂

[@astha_lakshmi_44]

Great video, the gallery is not filtered while selecting the dropdown. Could you please help with that. Or do you have any video on explaining how to connect these dropdowns with the gallery?

[@PowerAppsTutorial]

Thank you for the feedback! If your gallery isn't filtering based on the dropdown selection, you may need to adjust your filter formula. The formula generally looks like Filter(YourDataSource, YourColumn = Dropdown.Selected.Value).

[@almasmahfooz8217]

Good topic.

[@PowerAppsTutorial]

Glad you think so! 😁👍

[@carlw]

Great info thanks, but the data table is not filtered when you select any of the drop downs.

[@PowerAppsTutorial]

Did you get yours working ok?

[@carlw]

@@PowerAppsTutorial Yes, thanks for asking 😁

[@PowerAppsTutorial]

@@carlw Glad to hear! 😊

[@carlw]

@@PowerAppsTutorial BTW, neglected to mention I like your channel. Quite informative 👍

[@PowerAppsTutorial]

@@carlw Thanks so much. 😋

[@sdong2010]

Darren, you tutorial works great for the cascading functionality but it fails to actually filter the table

[@PowerAppsTutorial]

Can you post your challenge on my FREE community where you can get quick help: www.skool.com/power-apps-community

[@tonimodric2350]

Hallo, How Can i Patch Result from 3 Drop downs in new SharePoint List. Thx

[@PowerAppsTutorial]

Check out this video here: kzbin.info/www/bejne/pnyrqouvh5inj9E

[@BonusCup_72]

Hi, Great video. I'm having issues with my 2nd dropdown filter. I'm receiving a 'logical_test: A logical test to evaluate for each row. Only the rows that pass this test will be included in the result of the Filter' error. For the first filter, Status, I created a collection and that filter is working correctly. ClearCollect( colStatus, {Value: "All"} ); Collect( colStatus, Choices('Change Request Form-PMO'.Status) ); Do you know how I could resolve the error? TIA

[@PowerAppsTutorial]

Thanks for sharing the issues you're coming across. I've had some medical issues which has kept me away the past 2 months. Did you get your issue resolved?

[@nacimhoc]

Magnifique !

[@PowerAppsTutorial]

👌

[@sundrapillay6668]

Can you do an app with Dataverse thanks

[@PowerAppsTutorial]

Thank you for the video idea. I'll add it to my list. 😀👍

[@TracyOsimowicz]

Great video. But I ran into a big issue: Do you know of a workaround if I can't use the Distinct( ) function though? My data source is more than 3000 rows, so since Distinct is not delegable, it doesn't pull all of the data values I need.

[@PowerAppsTutorial]

What I do in those cases is break the data down into different tables. If you're trying to use Distinct() to get at a list of values, it is a good candidate for a new SharePoint list / database table.

[@TracyOsimowicz]

@@PowerAppsTutorial Gotcha. I appreciate the response! I'll take a look around your channel and see if I can find some relevant videos. In our case, we're currently trying to combine from 2 separate, unrelated data sources so we can (1) have those cascading dropdowns for all our form entry fields and (2) make updating the source data quick and easy. Ideally, I think our data would be in one place (one big source table) because not everyone who wants to update the form is literate in relational databases. But, if the relational data setup in SharePoint Lists is relatively easy to learn my team might consider it. Thanks again for the reply!

[@TracyOsimowicz]

@@PowerAppsTutorial I hear you. The problem is I need the dropdowns in our form to cascade, so I need Field 1, Field 2, and Field 3 to be connected. So, I need selected option and field 1 to limit my options I will then see in field 2, etc. I haven't found a way to connect the data that way outside of having them all in the same data source.

[@PowerAppsTutorial]

@@TracyOsimowicz So in this case, you'd want 3 different tables, then have a one-to-many relationship between them. This video steps through it. I hope it helps. :) kzbin.info/www/bejne/mWS1k2qtdqiUppI If not, here is a more thorough walkthrough of doing that: kzbin.info/www/bejne/gZizY4aVm9yrgKc

[@mariaangelesfebres]

hello how can I make dropdown lists but I have a lookup column in a sharepoint list to another list and I don't get the distinct function au help please

[@PowerAppsTutorial]

Hello! I'm not sure I understand what you're trying to do. If you tell me more about your situation, perhaps I can understand.

[@finalfant111]

I am having an issue with my Distinct showing duplicates in my dropdown. My function is as follows: Sort(Distinct(Filter(PricingList,Title=DataCardValue661.Text),RegionMarket),Result,Ascending). For some reason it is showing anywhere from 2 to 4 of the same item. I have gone into the list to see if I have a typo in several where a space might exist or something to create a "unique" version, but I cannot find anything like that. For all intent and purposes, this thing should only be filtering 1 of each. I have the same kind of cascading dropdown in other places in the app that work fine with the distinct, but this just baffles me.

[@PowerAppsTutorial]

Thanks for sharing. You're right, it shouldn't be giving you duplicates. I would have suspected spaces or some odd characters as you did.

[@finalfant111]

@@PowerAppsTutorial Do you have a suggestion what else to look at?

[@PowerAppsTutorial]

🍬 Get my free video course, access to my free community, and, if you would like, you can book a call with me here: go.superpowerlabs.co/opt-in-page-page ⬅

[@codyheiland5144]

Hey there, is there anyway to have the next drop down be blank until one before it is selected? For example: Job type would be blank, until category is selected

[@PowerAppsTutorial]

Sure. You can do a condition test to see if the previous drop down isBlank(), then set its items property to Blank() else, set its items property to the required records👌