Error on Automation Rule

Travis Hill_08pum3

Hello,

I am running into an error on automation rule and Im pretty sure its with how Im logging the returned items.

As you can see I try to add the result to a variable and then its erroring out on the branch saying that " is not a valid option. Can someone get a second pair of eyes on this? Thank you!

Bill Sheboy

Hi @Travis Hill 

As @Trudy P Claspill describes, we need to see more context to help.  Please post images of:

• your entire rule in one continuous image,
• the create variable action, and
• the entire audit log details showing the rule execution.

Until we see those...

 

I hypothesize at least two things are happening in your rule:

1. you are trying to merge values from multiple-selection (or checkbox) fields, in multiple issues (such as from a Lookup Issues result), to get the selected distinct values, storing that in a variable
2. you are then trying to update a single issue (e.g., the parent) to include the selections

 

For the first item, I recommend using the new flatten function to combine the values.  This eliminates the need for nested iterators and removing the square-brackets manually.  For example:

{{lookupIssues.customfield_12955.value.flatten().distinct}}

With that, the values could be iterated to create a dynamic JSON expression to update the field in the other issue using the multiple values:

{
  "fields": {
    "Business Unit Checkboxes" : [
      {{#lookupIssues.customfield_12955.value.flatten.distinct}}
        { 
          "value": {{.}} 
        } {{^last}}, {{/}}
      {{/}}
    ]
  }
}

 

Finally, with JSON expressions some smart values do not work and the custom field ID must be used instead.  If the above expression does not work, please try using the custom field ID in the JSON.

 

Kind regards,
Bill