Unable to search for values in Array

How To
1

I am pulling data from 2 tables in Airtable. One of them has a field Type, which can contain any combination of the values T1, T2, T3 and T4 (for example only T1, or T1 and T3 etc)

I use the Make “Get Record” module, and it gets this in the following format for example:

  • Type (Array)

    • 1: T2
    • 2: T3

Now from the other table, I get the record TypeP, which contains ONE of the values T1, T2, T3 and T4.

I am now trying to run a Search Record module, which searches if any of the values in the Type array is the value in TypeP.

However, no matter what I do :stuck_out_tongue: I am getting an error from Make saying "RuntimeError

[422] The formula for filtering records is invalid: Unknown field names: t2, t3"

Here’s what I tried so far:

FIND({TypeP}, ‘"’ & ARRAYJOIN({{{18.Type}}}, ‘", "’) & ‘"’) > 0,
FIND({TypeP}, ARRAYJOIN({18.Type}, ", ")) > 0,
FIND(TypeP, Type) > 0,

So the problem obviously is that Make is recognizing T2 and T3 as fields instead of values to look for, but I haven’t been able to find a way to make it understand that it should be looking for those values.

I assume it’s a simple Syntax problem, but so far no luck.

How can I approach this?

TIA!