This has to be a bug because I’ve already built this zap and it’s ran 100s of times the last few weeks until the past hour. In short, I only caught it when I noticed it didn’t run completely on the last trigger/input -- while other notifications did. Upon investigating, I realized the zap was halted/stopped due to the error in the title:
Error from halted execution: Nothing could be found for the search.
Which is weird, never happened before on this. The step in question is the lookup row function on Google Sheets to which it’s looking up a name, in this case let’s call it “John Appleseed”. John Appleseed is present on the sheet in row 8 of column A. But the zap is reporting that it cannot be found. However at the same time, in the same sheet, if I change the name of “Jane Doe” that’ on row 5 of column A, the zap triggers just fine.
The incident isn’t isolated to just John, it’s John and everyone else after him further down the column. The first 3-4 names are perfectly fine and trigger. But unfortunately for John and his colleagues, the task fails.
I’m fairly experienced with Zapier and have built some pretty cool things with it, but I’ve never seen this before and don’t have an explanation as to why this is happening as I’ve spent the past 40 minutes testing different inputs.
The closest thing I have is that the names are populated with a simple function:
=FILTER(Names!$A3:$A,Names!$B3:$B = TRUE)
But again, it’s worked before. It works fine for the first 3-4, and nothing afterward down the column…
Weird. Waiting for support to investigate and get back to me as well. Hoping someone has the answer or explanation
