Hi,
I have a Zap that looks for a row in Excel based off a date in a column.
At the moment it returns just the first row it finds with that date in - is it possible to return all rows that have that date in the relevant column?
Any help greatly appreciated.
Thanks :)
Jon
Hi
The Excel Find Row will only return 1 record, as you’ve discovered.
FYI: Most Zap triggers/actions/searches are configured to work on a per record basis, rather than in bulk.
NOTE: Be mindful that handling multiple records in line items (aka arrays) involves additional logic which can often mean more advanced concepts for configuring Zaps.
Consider using Airtable to organize your data instead of Excel.
Airtable has APIs that can be leverage: https://support.airtable.com/hc/en-us/articles/203313985-Public-REST-API
App APIs can be leveraged via Webhook steps in Zaps: https://zapier.com/apps/webhook/integrations#triggers-and-actions
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.