Power Apps: Cascade Drop Down List (Using Distinct)

Подписаться 19 тыс.

Просмотров 12 тыс.

50% 1

Power Apps Dropdown: Do you have controls that need to link together so that one filters based on the value of the other? We'll cover how to achieve this with drop down lists, but also explain how it could be applied to other listing controls like listboxes, gallerys, etc. Not only will we use the Filter and Sort functions, but we'll also make use of Distinct!
➡️ Get access to our free Power Apps crash course (and our community) here:
tinyurl.com/DarrensStuffFree 🔗
Darren Neese, Microsoft MVP, PowerApps Tutorial
TIMESTAMPS =======================================
0:00 - Intro
0:54 - Discussion on different listing controls
3:53 - Duplicate problem and how to use Distinct
6:50 - Filter and sort the 2nd drop down list
8:55 - 3rd level of cascade
10:26 - Warning about using Distinct
11:45 - Message from Nicole
CODE FIX =======================================
At the 10:08 mark, the code should rather be this:
Sort(
Filter(
tblJobTypes,
JobTypeText = ddlSalesEdit_JobType.SelectedText.Value
),
JobSubType
)
Here's the official documentation on the Drop Down List control:
docs.microsoft.com/en-us/powe...
#PowerApps
#PowerPlatform
#LowCode

Опубликовано:

21 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 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! 😄👍

@OB-HCP4 6 месяцев назад

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

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

@nacimhoc 6 месяцев назад

Magnifique !

@PowerAppsTutorial 6 месяцев назад

👌

@astha_lakshmi_44 6 месяцев назад

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 6 месяцев назад

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

@PowerAppsTutorial 9 месяцев назад

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

@almasmahfooz8217 2 года назад

Good topic.

@PowerAppsTutorial 2 года назад

Glad you think so! 😁👍

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

@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 8 месяцев назад

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👌

@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

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

@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. :) ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-c3Rb7wACap0.html If not, here is a more thorough walkthrough of doing that: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-KgP2S_fwxJE.html

@tonimodric2350 Год назад

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

@PowerAppsTutorial Год назад

Check out this video here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-pKHyXyR3tYo.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. 😀👍

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

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