Filter items on criteria which can be found among multiple values

[ArturasF]

Hello, imagine we have simple data table:

ClearCollect(colTest,
{Name: "A", Fvalues: "1,2"},
{Name: "B", Fvalues: "3"},
{Name: "C", Fvalues: "1,3"},
{Name: "D", Fvalues: "2"});

If our filter criteria = 1, the expected filtered items should show A and C

if criteria = 2 then A and D

if criteria = 3 then B and C

Is it possible to do? How filter statement should look? Fvalus format can be adjusted. I just used comma separated delimeter.

[ArturasF · Accepted solution]

I have tried

Filter(colTest,"3" in Split(Fvalues,","))

Previously it didn't work... it works now. Unable to delete this post, sorry for wasting time.