Best answer

How can I compare nulls with the filter?


Userlevel 1
Badge

I'm using the "Updated Organization" trigger from https://zapier.com/apps/channeltivity/integrations.

A sample trigger has the following payload:

id
7502
preChanges
logo_png_url__c: null
postChanges
logo_png_url__c: null

When I try to use a Filter to only continue if they’re different, it appears that it says the nulls are the same:

 

 

How can I compare the nulls to only proceed if they’re different?

icon

Best answer by Troy Tessalone 18 May 2022, 03:24

View original

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

Userlevel 7
Badge +14

Hi @zap29550 

Good question.

Try using these logic conditions to the Filter step…

PRE does not exactly match POST

AND

PRE exists

AND

POST exists

 

Userlevel 1
Badge

@Troy Tessalone I don’t think that will work if PRE is null and POST has a value? 

Userlevel 7
Badge +14

@zap29550 

Try these Filter conditions

 

GROUP 1

PRE does not exactly match POST

AND

PRE exists

AND

POST exists

 

[OR]

 

GROUP 2

PRE exists

AND

POST does not exist

 

[OR]

 

GROUP 3

PRE does not exist

AND

POST exists

Userlevel 1
Badge

I think that will work. I will give it a try. Thank you @Troy Tessalone