Skip to main content
Best answer

Filter doesn't stop flow when it returns a False result. Why?

  • December 16, 2022
  • 4 replies
  • 169 views

I have an Action setup with a “Lookup Spreadsheet Row in Google Sheets”

I also have “Should this step be considered a "success" when nothing is found?” set as “No”  but keeps going with the next step anyway.  

Best answer by Troy Tessalone

Hi @Petrugals 

Good question.

Try this.

Set that GSheet step field condition to Yes, then add a Filter as the next step to check the conditions you want.

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Danvers
Forum|alt.badge.img+12
  • Zapier Staff
  • 3731 replies
  • December 16, 2022

Hi @Petrugals 

Hmm, that doesn’t sound right, could you share an example from your Zap history of when this has happened? Specifically if we can see the data in and data out for the Google Sheets step, that would be super helpful. Don’t forget to remove or obscure any personal or private information in any screenshot you share in the community (eg full name, email address, etc).

Thanks!


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • 34001 replies
  • Answer
  • December 16, 2022

Hi @Petrugals 

Good question.

Try this.

Set that GSheet step field condition to Yes, then add a Filter as the next step to check the conditions you want.


GetUWired
Forum|alt.badge.img+12
  • Zapier Solution Partner
  • 1030 replies
  • December 16, 2022

Hi @Petrugals 

Zapier independently evaluates each step when the zap runs so only steps dependent on the search step results will get stopped (steps that have data from the output of the search step). So as an example if i have a zap with 5 steps like so: 

Trigger
Action 1 (Search Step)
Action 2 (not dependent on results from step 2.. ie. nothing from step 2 is mapped)
Action 3 (dependent on results from step 2.. ie. something from step 2 is mapped)
Action 4 (not dependent on results from step 2.. ie. nothing from step 2 is mapped)

Then when my search step throws a halted error only Action 3 would be skipped since Action 2 and Action 4 don’t use any output data from the search step. 

I hope that helps! 

if you want the entire zap to stop after the search step, you will need to either use a filter and stop when the Zap Data Was Found field is false or make sure every step after the search step uses at least 1 output field from the search step. 


  • Author
  • Beginner
  • 2 replies
  • December 17, 2022

Thanks everyone.  I believe I have it working correctly now.  I changed the GSheet step field condition to Yes, then add a Filter as the next step to check the conditions before continuing.