Power Apps: Cascade Drop Down List (Using Distinct)

No video

Power Apps: Cascade Drop Down List (Using Distinct)

Рет қаралды 12,352

PowerApps Tutorial

Күн бұрын

Пікірлер: 39

@PowerAppsTutorial 2 жыл бұрын

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

@atxvet 2 жыл бұрын

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

@PowerAppsTutorial 2 жыл бұрын

Thanks so much! 😄👍

@PowerAppsTutorial 11 ай бұрын

🍬 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 ⬅

@ChauNguyen-mg1oc 2 жыл бұрын

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 2 жыл бұрын

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. 😂

@OB-HCP4 7 ай бұрын

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

@astha_lakshmi_44 7 ай бұрын

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 7 ай бұрын

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 2 жыл бұрын

Good topic.

@PowerAppsTutorial 2 жыл бұрын

Glad you think so! 😁👍

@sdong2010 2 ай бұрын

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

@PowerAppsTutorial 2 ай бұрын

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

@nacimhoc 7 ай бұрын

Magnifique !

@PowerAppsTutorial 7 ай бұрын

👌

@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. 😋

@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?

@tonimodric2350 Жыл бұрын

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

@PowerAppsTutorial Жыл бұрын

Check out this video here: kzfaq.info/get/bejne/prF4rLuqt5nYiaM.html

@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. :) kzfaq.info/get/bejne/mZmClZqopqnFoGQ.html If not, here is a more thorough walkthrough of doing that: kzfaq.info/get/bejne/gc2AZbaQy93cenk.html

@sundrapillay6668 2 жыл бұрын

Can you do an app with Dataverse thanks

@PowerAppsTutorial 2 жыл бұрын

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

@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?

@mariaangelesfebres 2 жыл бұрын

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 2 жыл бұрын

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.

@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 10 ай бұрын

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👌