I am trying to use an automation with the following setup :
- Trigger : When a record is created (in Table 1)
- Action 1 : Find record (in Table 2), where Name = Field 1 from Trigger
- Action 2 : Update record (in Table 1), with Record ID = Airtable Record ID from Trigger
In this action 2, I am trying to update several fields using field values from Action 1.
However, I noticed that the automation is only working when ALL fields from Action 1 used in Action 2 are not empty. If at least one of these fields is empty, the automation will fail with the following error message : Failed to construct the value for “Fields”.
I suspect that the Find Record action only bring fields with non empty data and ignore the others.
Is it the expected behaviour ? Any workaround that doesn’t involve creating a formula field for each field that I am trying to get the value from in Action 2 (because I really have a lot of them) ?