Google Sheet Lookup Step success/fail result not showing up in subsequent filter options unless "Create Row if nothing exists" is selected

Hi @AshleighDLC 

The Zap will now return this data point that can be used in Filters

Hi @Troy Tessalone 

I just checked one of my zaps again and it is still doing the same thing. Unless I check “Create row if none exists”, it does not return a search result status to use in a filter. 

I have attached some screen shots. I left Action 3 as is, without the create row box checked, and in the filter did several field searches that should have brought up the look up result and you can see nothing comes up. 

Then I changed Action 4 (which is normally set up the same way as 3) by checking the create row box, and you can see in the filter search that the look up result comes up immediately. 

When I first opened this zap to make an adjustment, the filter dropdown where I had previously entered the zap look up result in was empty. I have multiple zaps that use a filter like this and I’m concerned that they may be filtering incorrectly if this isn’t working.

@AshleighDLC 

I was able to replicate the use case.

I’ve gone ahead and flagged this post for the Zapier Team to review.

I’ve also submitted a ticket to Zapier Support on your behalf here: https://zapier.com/app/get-help

@AshleighDLC

Here’s the response I got from Zapier Support:

I took a look a the article and I was able to reproduce it as well.

It looks like it's a platform level issue as I could reproduce with Airtable and Google Sheets searches.

I don't think it was intentional.

I've gone ahead and created a bug report so that we can look into this and we'll notify you automatically when it's resolved.

Hi @Troy Tessalone  Thanks for that. When they say that they will update automatically, will that update also go to me?

@AshleighDLC 

Not sure since I opened the ticket, but mentioned this Zapier Community article indicating you were the original reporter.

You can always reach out to Zapier Support to have them make sure you are included on the update statuses.

Hi @AshleighDLC!

I’ve added a link to this thread in that bug report, so an update should be posted here when that’s been resolved :)