how to pass data from one Drop down to other drop down using filter in SAP build Apps

[basilshashmi]

Hi,

i am currently creating an App using ODATA service. I have two entity sets ( each with 4 fields ) and i am using them in two different drop down. I need to pass the data of one drop down as a filter to the second drop down.

i have tried alot but the filter doesnt seem to work.

is it because i need to pass some value in the condition tab below ? if yes can someone guide me as what i need to do here.

when i check in backend, there is no filter getting passed :

hope for a positive response .

Thank you

Basil Hashmi

[Dan_Wroblewski]

The mapping binding is for use with data components, so you can bind data fields to component properties. To be honest, not sure when and why it appears in this case.

To do what you did, I created a POC using Northwind Category entity (level 1) and Product entity (level 2), using the Category dropdown to filter the product dropdown.

The 2 dropdowns get filled as usual, from MAP formula with data variables. Nothing special. On the change event for the first dropdown, you simply retrieve the products with a "Get record collection" flow function with a filter. The filter just uses the page variable bound to the category dropdown.

You could also just retrieve all the products once in a variable and sort on that variable. When I select the first category, you can see that only products with that category are selected.