Skip to main content
Question

Usual "concatenate trick" to solve "Cannot assign list of string to string" doesn't work

  • May 28, 2026
  • 3 replies
  • 24 views

Forum|alt.badge.img+17

Hi,

Using “When a record matches conditions” I want to “Find records” using a result in a previous “Find records”. That result is originally a LookUp, which result I know I can’t use as a dynamic condition in an automation, giving a “Cannot assign list of string to string” error.

Hence I created a formula field which CONCATENATEs the LookUp to what I though is a string. Regardless of that, I still get the same error, and cannot use the new formula field in the automation either.

The result is a recordID so cannot format these into single selects, they are unique.

What have I forgotten about how these work 🤔?

Rgds,

Björn

3 replies

Forum|alt.badge.img+17
  • Author
  • Known Participant
  • May 28, 2026

UPDATE: I realised I don’t need a separate Find records step, I can do a direct Update record. There both the lookup and the formula version work. 

Would still like to understand how to deal with the Fin records, for future reference.

Rgds,

Björn


ScottWorld
Forum|alt.badge.img+35
  • Genius
  • May 28, 2026

@0800-grizzly 

To turn a lookup field into a string, you would need to append an empty string of text like this:

{Lookup Field} & ""

- ScottWorld, Expert Airtable Consultant


TheTimeSavingCo
Forum|alt.badge.img+32

Yeah that’s because ‘Find Record’ is returning an array, not a single result

I usually add a ‘Run a script’ step to convert it into a string / number as needed

@Alexey_Gusev has a simpler nocode workaround using an ‘Update record’ step and updating nothing for the record in question, and then using the ‘Update record’ step’s output for the next Find Record step.  You’ll need to have a field that you’ve set up specifically for this though so that you can update it as a blank though I think?  Alexey, apologies if I’ve misunderstood what you meant; any errors are my own!