Copy the latest Value From One Table to Another

[googlenoob62]

In my application, there are two tables named Table_1 and Table_2. I need to get the most recent 'Status' value for a given customer from Table_2, based on the latest date, and then update the 'Status' column in Table_1 corresponding to the same Customer Number.

I've tried each of the following expressions in an Action with a Bot to make the change when an entry is added to Table 2 but, have had no luck in getting them to work:

• MAXROW("Table 2", "Status", ([Customer Number] = [_THISROW].[Customer Number]))
• ANY(SELECT(Table 2[Status], [Date Changed]=MAXROW("Table 2", "Date Changed",([Customer Number]=[_THISROW].[Customer Number]))))
• LOOKUP([_thisrow].[Customer Number], "Table 2", "Customer Number", "Status")

[googlenoob62 · Accepted solution]

I figured it out with this expression:

LOOKUP( MAXROW( "Table 2", "Date Changed", [Customer Number] = [_THISROW].[Customer Number] ), "Table 2", "Customer Number", "Status" )