I have a weekly schedule zap that has a “find many records” action to start so that it can find all the fields in my airtable base that have status set to active. I then have a “create loop from line items” which loops a “find record” action and email so that it can go through all the records retrieved from the “find many records” action and send an email for each one. The problem I am encountering is all the records are being retrieved at once and sent together instead of individually and so when it comes to the find record step it keeps failing because it is expecting to deal with a single record. For more context, the find record step is matching the record ID from the table accessed in the “find many records” step to the ID in another table. But since the output it is receiving has the record ID of multiple records together and only separated by a comma, it will never work because it is expecting only one record ID. Any suggestions on how to fix this? I tried adding a split text formatter after the “find many records” step but the output still didn’t solve the problem
Best answer
How to fix looping issues with Airtable records in Zapier

Best answer by Troy TessaloneBest answer by Troy Tessalone
Each line item variable from the Airtable step should be it’s own input data point in the Looping step.
Click the button [Add value set]

Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.