Hi all, hoping the hive mind can solve for what I think may be a common use case. Here we go…

I have two tables:

Table 1: List of records from form submissions. Records are only added to this table. Records are linked to another table with multiple look up fields. We have an automation that when a record is created in this table it finds a record in Table 2 by matching against a unique identifier and updates the lookup fields. If the unique identifier is not matched, the linked and lookup fields remain empty as seen in the screen grab below. Table name is named 1. Onboarding Form

Table 2: List of records that is overwritten daily by an external sync. With any given update, records remain, are added to and/or fall off the list so it’s not a situation of “when a record is added”  or “enters a view”. Table is named 2. Sync from Volunteer Leadership

Objective: Set up an automation whereby any record in Table 1 where the linked record field is empty attempts to lookup records in Table 2 based on that same unique identifier. 

Trigger:

Note: Selected the above trigger because the Find Records action has a maximum threshold limit that exceeds any grid view I can create. 

Find Records

Update Record: This is where it’s getting tripped up.

I’ve tried many configurations and can’t get this to work. Fully aware I may need advanced logic but nothing seems to work. Any guidance you can offer for getting this to work is greatly appreciated. To say I’m missing the Ask an Expert sessions is a understatement. :)

Thanks all!