This probably has broader application, but the specific scenario is the “HubSpot Find Contact” action, using the “Email” (hs_email) and “Additional Email Addresses” (hs_additional_email) fields.
When searching for a Contact in HubSpot using the Contact’s email address, I don’t know which of the two email fields the target value might be in, so I need to search both fields. Unfortunately, the multiple search properties of the existing control only perform an AND search (all conditions are true). I need to perform an OR search, to find if the target value is in hs_email OR hs_additional_email. If there were a configuration option to perform an OR search (any condition is true), it would do exactly what I need.
If my search value is found, I grab the recordID of the target record and then perform the same subsequent steps regardless of which field the email is found in. So a PATH step doesn’t work for me (unless I were to duplicate the subsequent steps under each path).
Any suggestion on how to handle this OR-search need?
This same OR-search option would be useful on all of the HubSpot “Find xxx” actions, as well as the similar Dynamics CRM Find xxx actions