Answered

Cascading Dropdown with Multiselect Lookup SharePoint field

(0) Share

Report

Posted on by RCSmart01

22 Microsoft Employee

I have two tables one called Genre and the other called Media Type. In genre there is a lookup field to media type (called MediaType) that allows multivalue choices. What i would like to do is create a cascading dropdown; I have two dropdowns in my powerapp one dropdown is call Type and the other is called Genre. I want to filter the Genre dropdown using the type drop down, but since the Mediatype column in Genre is multivalued PowerApps is giving me a hard time filtering that column. What is the best way on doing this?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RCSmart01

See my post here and check out #1 and 2 https://powerusers.microsoft.com/t5/News-Announcements/The-Ten-Commandments-of-SharePoint-in-PowerApps/bc-p/849014

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi@RCSmart01,

Based om the issue that you mentioned, do you want to filter the Genre based on the multi select LookUp column?

Could you please tell me more about your scenario?

I have a test on my side, please take a try as below.

Set the Items property of the Genre Dropdown as below:

Filter( Genre, CountRows( Filter( ForAll( Type.Value, If( Value in ComboBox1.SelectedItems.Value, {t: 1}, {t: 0} ) ), t = 1 ) ) = CountRows(ComboBox1.SelectedItems.Value) ).Genre

Note: Combo Box1 represents the LookUp column Type.

Hope it could help.

Regards,

Qi

Was this reply helpful? Yes No
RCSmart01 22 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

The type field and the genre field are both drop downs as they will only be selecting one. The reason for the multiselect type field is because there are repeats of genre in different types and didn't want to put duplicates in the SharePoint list.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi@RCSmart01,

I am not quite sure what your scenario looks like, but based on the formula I provided, I will show you how I understand your scenario.

So I assume that you want to filter the Genre based on the NewType column.

Please try the formula I provided before to check if it could solve your problem.

If not, please give me your sample data.

Regards,

Qi

Was this reply helpful? Yes No