Help with repeating group and searching for item, not first item or last item

Need help Database
1

I have a confusing problem to explain, but it involves a repeating group, and doing a search for app data, but not a first item or the last item. I want to make the repeating group so that it searches for an item and it doesn’t matter where it is located (first or last).

Please help if you have any ideas. Here is a quick video I made to hopefully help you understand.

2

Not on my pc right now, however, have you tried ‘contains’ instead of the ‘=’?

Maybe that will do the trick.

3

For some reason that is not an option. This pops up, when I try to switch the ‘=’ to ‘contains’

pop up

4

Any ideas?

5

Is ‘color’ set up as a list, or a single item?

6

color is set up as a list.