Troubleshooting the Search for related record node in Salesforce with missing search value

Hi ​@DKaetzer 

Required fields must have a value.

For us to have true context, post screenshots showing how your Zap steps are outlined and configured in the CONFIGURE tab while in EDIT mode with the field mappings visible.

Oh OK - so the “Or” function is not really an OR function then? Since regardless it requires that initial value to be present? Can I remove the required setting?

​@DKaetzer 

For us to have true context, post screenshots showing how your Zap steps are outlined and configured in the CONFIGURE tab while in EDIT mode with the field mappings visible.

​@DKaetzer 

You can add Paths to have different Salesforce step search logic based on which Zap step 1 fields have values.

https://zapier.com/apps/paths/integrations#help

Hey ​@DKaetzer,

It’s because your passing an empty value. You are correct that it’s an OR operator but the first search value field is required as you can see the red asterik over it. If one of the search field will always have data you can put that in the first search value and it will fix your issue.

If it’s not sure which field will have the data, try using Formatter → Text → Default Value to pick the field with data. In the input field pass the first field and in the default value to the second field. After this map the output of this to Salesforce Find Record action. Hope it helps!

Hey ​@DKaetzer 
 

This happens because even with OR selected, Zapier still requires Search Value 1 to have data. If it is empty, the step fails before checking Search Value 2.

Quick fix
Make sure Search Value 1 is never blank. Use a Filter or Paths so this step only runs when that value exists, or use Formatter by Zapier to pass the first non empty ID into Search Value 1.

Helpful docs
https://help.zapier.com/hc/en-us/articles/8496288699661-How-to-use-Find-or-Search-actions-in-Zapier

https://help.zapier.com/hc/en-us/articles/8496259234573-Use-Paths-by-Zapier

https://help.zapier.com/hc/en-us/articles/8496308436237-Use-Formatter-by-Zapier