Dynamic JO logic flow (avoiding null email failures and dropped participants)

@dayn.johnson 

I was in a similar situation a week ago and had to revert back to using the older version of JO due to its ability to have custom email mapping.

The issue I was running into was that in my “Audience” step, I was pulling contacts in my first step and in subsequent transformation, I was eliminating null email id for the accounts that didn’t have a CSM assigned via a case statement. 

I then had an evaluate step to that basically was checking if the email should go via the CSM or a generic email address. The CSM email address was tokenised in one branch of the flow, while the other branch had the generic email address hard coded in the sender email field.

Now, the contacts whose accounts didn’t have a CSM and were supposed to receive an email from the generic email address but were dropped from the program because the sender email address for a subset of these contacts was NULL even though these subsets of contacts were supposed to receive email from a generic email address.

Update to this post -- after some discussions in the GGA Slack community around an acknowledged bug (my support ticket on the issue is #337253), @heather_hansen had a similar issue:

 Overview: JO participants aren’t routed through the correct branches following an evaluate step (works with a query source, not with a Data Design).

• Issue Details: In Dynamic JO, DD as source and when evaluate step is built on email datatype participant fields, the evaluation is not happening properly.

My workaround (newly published dynamic JO is running correctly): changing the evaluate step from evaluating the account team’s email addresses to evaluating their name (through a calculated field so I didn’t have to add additional fields to my DD source).

The outcome: based on whether all the account team was not null, or if there was at least one field that was null, my new dynamic JO (based on a DD source instead of a query so it’s able to be edited in the future) is running successfully!

Thanks for sharing, @dayn.johnson!  I wound up doing the same.