Help in reverse lookup

AppSheet AppSheet Q&A
,
1

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=???’

2

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.

2 Likes
3

Superb :blush: , it’s working like a charm. @WillowMobileSys you made my day.

2 Likes