Help in reverse lookup

[arunkw]

I have 2 tables

Table 1 

Description	Owner List	Updated
Marry had a little lamb		No
London bridge is falling down		No
Little miss muffet		Yes

Table 2

String	Owner
little	Marry
london	Queen

What I want to happen is if the 'Updated' value is 'No' then fill-up the 'Owner List' with 'Owner' wherever 'String' is found in 'Description'. I am guessing I will need to use reverse lookup and/or fuzzy search. I don't know how to use it, please help.

Things I have done till this point are - Create action for Table 1 

Action 'Run the update' with 'Data:Set the values of some columns in this row' 

Behavior: Only if this condition is true '[Updated]=No'

Set these columns as 'Updated=Yes', 'Owner List=????????????'

[WillowMobileSys · Accepted solution]

This is not a lookup.  You need to compare String in Table 2 with Description in Table 1 to see if Description CONTAINS() String.  Then select the Owner value.  The expression would look like this:

SELECT(Table 2[Owner], CONTAINS([_THISROW].[Description], [String]))

 This will return a list of Owners if there are multiple matches.

[arunkw]

Superb 😊 , it's working like a charm. @WillowMobileSys you made my day.