Automation action "Find records" showing "no valid nested values" for dynamic values

[Remy_Smith]

I'm setting up an automation triggered by updating a field in one table, which updates a field on the linked record in another table. I'm using "Find records" to search the linked table based on condition that the record's name/title matches the name/title of the linked record from the source. Essentially, I'm just trying to find the record linked to the updated record.

However, when selecting "Dynamic" for the condition value, the name/title field to be used is not selectable, with the pop-up message of "no valid nested values" when hovering over the field. It really seems like this should work, and this error message is cryptic and not helpful.

Does anyone understand this "no valid nested values" error?

Should I be grabbing linked records to be updated in a different way?

[TheTimeSavingCo · Accepted solution]

> Essentially, I'm just trying to find the record linked to the updated record.
Hm, what if you used an "Update Record" immediately to update the record linked to the updated record like so? 

Link to base with automation

If the above doesn't meet your needs, would it be possible to share your base with some example data so that I can troubleshoot it?

[Remy_Smith]

Thanks Adam! That did the trick. I didn't realize you could reference a linked record using its ID instead of its name. I can probably use this to optimize some other automations as well. I appreciate your help.

[Databaser]

Genius 💪