Don't Find dynamic data in "Find Record" Step

[Admin_Promis_Ju]

Hello,

in an automation i try to find records based on conditions on a linked record. When i try to find the value from the record triggered, I find it but i can’t insert it.
here is the video : Loom | Free Screen & Video Recording Software

[Amit_Merckado]

I encountered the same issue:

I’m trying to find a record using automations, but the record I want to search with can't be inserte... Automations

I have 3 tables: 1 - Incomes, 2 - Outcomes and 3 - Monthly reports. I’m trying to link new records in tables 1-2 to the appropriate record in table 3. in tables 1-2 I have a formula field which gives year and month (e.g. “2021 01”). The 1st column in table 3 is “YYYY MM”. I created automation that trigger in new record in table 1, finds the matching record in table 3, and updates it with the newly created record. And it worked as planned! When I tried to do the same thing on the 2nd table I …

[Lee_Pettijohn]

Following this post to see answer

[Tuur]

You can work around this by adding e.g. a rollup field with the ID from the other record. This can be inserted.

[Admin_Promis_Ju]

i ll check your proposition ! TY

[Kris_Wigness]

Hi. Any. luck in getting this to work? I am trying to do the same thing. Your video is exactly the issue that I am running into. I cannot search the second table for names that match the “name” of a record in the first table. I want to be able to automatically link the appropriate record in the second table to the record in the first, but without the ability to find the matching name, I am stuck (unless I turn to Zapier or Integromat)

[Alexander_Stump]

i have the same issue, have tried a myriad of different approaches, but this is simply a bug, please help dear airtable team @Airtable_Clerk @AirtableGuru :slightly_smiling_face:

[Guillaume_Blan1]

What you can do as a workaround is to add an Update record Action step before your Find action that updates the value use for the search in a text field. You will be able to use that text field in your Find action. Hope that it’s clear.