Filter Condition using Google Sheet Lookup Result

Status: Closed · Asked by Majeem M. on · 0 views

mjm — Question ·

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 — Reply ·

Hey @mjm

Please check out the following screenshot on your concern -

mjm — Reply ·
Hey @mjm

Please check out the following screenshot on your concern -


But the parameter is not common for both conditions for me.
mjm — Reply ·

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

Pabblymember11 — Reply ·

Hey @mjm

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

[IMG width="406px" alt="2021-11-26_11h03_08.png"]https://forum.pabbly.com/attachments/2021-11-26_11h03_08-png.5722/[/IMG]

Back to all forum threads · Log in to reply