Help with filter step

[Carlos Melo]

Your Task History ID

IjU3NjUwNTZlMDYzMTA0MzQ1MjY4NTUzNDUxMzQ1MTZhNTQzMzBmMzEi_pc

Hello,
I'm having some difficulty with the filter step, because it's not filtering the way I configured it.
I have a workflow that should prevent events from moving forward if one of the 'or' type conditionals is met, but that's not what's happening. Here is the workflow:

Pabbly

connect.pabbly.com

The filter is step number 9.
But it is letting the events go ahead even if one of the 'or' conditionals has a data point, i.e. if a certain number exists in one of the 7 previous spreadsheets

If you check the history you will see that step 7 has the number that should stop the flow from going ahead, but it still continues.

I am using the "Does not exist" filter type. Should I be using another type, like "is empty"?

 

[ArshilAhmad]

Hi @Carlos Melo,

You have set up the filter in Step 9 in such a way that if any of the lookup tables from Steps 2 to 8 do not return any data, the workflow will still continue.
Based on your Task History, we can see that Step 2 of the workflow didn’t return any data, so the workflow continued.

 

[Carlos Melo]

Thank you @ArshilAhmad.
Ok, so now I've set all the conditions as "Exists" and the filter is still letting the flow go ahead.
There is data on the step number 2.
Please check the Task History ID: IjU3NjUwNTZlMDYzMTA0MzQ1MjY1NTUzMDUxMzQ1MTY2NTQzMzBmMzAi_pc

Just to be clear, I don't want the flow going ahead if one of those Spreadsheet has any data.

What do you suggest I do?

 

[Carlos Melo]

I also have used ‘Filter Type’ as “Is empty” and the filter let flow going ahead if there is data in any of those spreadsheet.

 

[Carlos Melo]

Hello,
Can anyone answer me here, please ?
How can I set the filter step so that it can work as I need ?

 

[Preeti Paryani]

Hello @Carlos Melo,

Apologies for the delayed response.

If you'd like the workflow to proceed only when the searched data does not exist in any of the sheets, we recommend using the AND condition operator in your filter instead of OR.

You should set the filter to check for a "doesn't exist" condition. This ensures that if the key Response Result 0 RowValue 0 exists in any step's response, the workflow will not proceed further.