Power Platform Community Forum Thread Details

I'm not really sure how to word the question but here is what I have.

Two dropdowns. One for Medium and one for Medium Details
Medium has a primary column named Medium Name which contains values such as Banner, Video, Text Link, etc....
Medium has a secondary column named Medium Detail Type which contains values such as img, vid, lnk
Medium Details has a primary column named Medium Detail Name with values such as img-1, img-2, img-3,vid-1, vid-2, vid-3, lnk-1, lnk-2, lnk-3

Initially, I was trying to make the Medium Details dropdown dependent on Medium by using a formula like this which worked when I was using comboboxes:

Filter('Medium Details', Medium_CB.Selected.crfeb_mediumdetailtype in crfeb_mediumdetail)

Besides this not working I didn't think it was efficient. Since then I added to the Medium Details data source a column for Medium Detail Type.

What I am looking to do now is return the Medium Detail Name where both Medium Detail Type from both data source match. I've a number of searches and tried a number of solutions but I'm just not landing on the right one. Most of the cascading tutorials out there are not comparing secondary columns.

Categories:

General Questions