Skip to main content
Best answer

How can I compare nulls with the filter?

  • May 17, 2022
  • 4 replies
  • 135 views

Forum|alt.badge.img

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?

Best answer by Troy Tessalone

@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

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

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • May 18, 2022

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

 


Forum|alt.badge.img
  • Author
  • Beginner
  • May 18, 2022

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


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Answer
  • May 18, 2022

@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


Forum|alt.badge.img
  • Author
  • Beginner
  • May 18, 2022

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