Compare two fields with Text contains

I have two tables (table1 and table2).
I want to perform an inner merge query with both tables.

I want to check if the parttial name field in table1 is found in table2 may be by using Text.Contains. I am not quite familiar with this.

Any help please please please.

>Solution :

To test if table1.Name is contained within a row of table2.Lookup Value:

in table1, add column … custom column … with formula:

= List.AnyTrue(let a=[Name] in List.Transform(Table2[Lookup Value], each Text.Contains(_,a)))