Canvas PowerApps - Bind ListBox OnChange of Dropdown

[SanjayAdsure201]

Dear All,

We've a SharePoint List named College having column names as Department (Single Line of Text) & Subject (Choice column with Multiple Selection). One Department have many Subjects. Now on PowerApps form we have Department as Dropdown & need to use Listbox to show Subjects.

I can see all Departments listed in Dropdown. For ListBox Items property, if I use Choices(College.Subjects), I can get all Subjects in listbox. But now I want to filter it based on Department. So on change of Department, I want to filter Subjects & bind to ListBox.

Can you please help me how can I achieve this?

Thanks & Regards,

Sanjay Adsure

[Rusk]

For the Subjects dropdown, you need to filter the Items to match the Department dropdown.  This video explains it well and will walk you through it (thanks to @ShaneYoung)

https://youtu.be/SKMwayf_cuM

[WarrenBelz · Accepted solution]

Hi @SanjayAdsure201 ,

You have an additional issue with the multi-select. You did not state the Items of your Department drop-down, so I do not know the output (Value/Result/FieldName), so replace xxxx below

Sort(
   Ungroup(
      Filter(
         College,
         Department = YourDepartmentDD.Selected.xxxx
      ).Subject,
      "Subject"
   ),
   Value
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications)   Visit my blog Practical Power Apps

[SanjayAdsure201]

Thank you @Rusk for your reply & nice video!

Thank you @WarrenBelz! You grabbed it correctly, it's that Multiselect I was facing issue with! Your solution gave me exact filtering!