Filter Condition using Google Sheet Lookup Result

[mjm]

How can we add a filter under a router based on the Google Sheet Lookup Result?

I want the Router to have 2 Steps.

1st Step = When Lookup fetched Result/s
2nd Step = When Lookup fetched No results.

I am unable to find a common value to use for the filters to differentiate between the 2 scenarios.

 

[Pabblymember11]

Hey @mjm

Please check out the following screenshot on your concern -

 

[mjm]

Hey @mjm

Please check out the following screenshot on your concern -


View attachment 5720

View attachment 5721


View attachment 5722

But the parameter is not common for both conditions for me.

 

[mjm]

When LOOKUP fetches no result, I have below response. But none of these parameters are available when LOOKUP fetches result/s.

 

[Pabblymember11]

Hey @mjm

Yes, when LOOKUP fetches no result then the 2nd route will work because that field that we have mapped would exist.