Filtering data in a repeating group and data base

[bruno1]

Hey guys,

I hope someone can help me with my data filtering use case.

I have a data type called Products which has 10 fields, one of which is Delivery Name (list of Delivery Services- another data type). Then, I created a repeating group to display Products data type and want to filter this repeating group using a dynamic dropdown.

I managed to make work the filtering by Product Name, but for some reason Delivery Name filtering is not working.

See screenshot below:

Does anyone know how to fix it?

Thanks,
Bruno

[jeffrey.j.obrien]

Looks like a mismatch - list of Delivery Services and a single item select dropdown.

When its a list, you should use Contains rather than =

[bruno1]

Thanks @jeffrey.j.obrien! It’s working now

However, I have a new issue related to dropdown elements that I can’t figure out the solution.

I added a constraint in the Repeating Group to display only data that the field availability = No, then added two dynamic dropdown elements to filter data in the repeating group where a dropdown 2 depend on the choice of dropdown 1.

Now the dropdowns are giving the option to select and filter all data of the Products Data Types, and I don’t know how to filter and display only the data with availability = no.

Do you know how to fix it??

See screenshots below.

Screenshot Dropdown 1

Screenshot dropdown 2

Screenshot repeating group