A method to filter multiple data value in the same time

[Evendo]

Hi, I'm an Appsheet newbie!

I have a data table which contents records that having multiple tag values, delimited by comma "," and end-users could be add, change or delete these tags.

Now I'm creating a filter page which end-users could be select multiple tag choice for data managed by the table before. The users' filter choice is managing by a separate filter table.

Is there a way to compare and filter data records matching users' choice? I'm now having problem with this as it's now filtered correctly with data having single tag only but not multiple.

For example, I having 4 data records

1 tag = yellow,red,blue

2 tag = violet

3 tag = blue,yellow

4 tag = grey,blue

Then if a user choice to filter record with 2 different tags "yellow,blue" on filter page (via an enum-list), I want to filter and show record 1, 3 and 4 on data result list.

If a user choice to filter record with tag "yellow" on filter page (via an enum-list), I want to filter and show record 1 and 3 only.

Please give me some advices. Thanks so much!