Set condition to run automation with only value match with lookup table

Question

I created an automation rule to update the Slack user ID in Jira tickets as follows:

* The rule triggers every time an issue is assigned.
* I defined 'slack user' using a lookup table with keys (Jira user IDs) and values (Slack user IDs).
* If the 'assignee ID' matches a 'slack user ID' in the lookup table, the field is updated accordingly. If there’s no match, it currently changes to "none."

Is there a way to set a condition so that the automation only runs when there is a value match in the lookup table? In other words, if there's no match, it shouldn't change to "none."

Note: I’d like to optimize this rule to reduce my automation usage count.

Bill Sheboy · Answer

First, your rule steps are out of order: the condition should be after the table is created!

Next, there is a typo in your condition you highlighted: there is an "a" before the issue smart value.

Finally, I believe you want the condition to be "not equals" empty, thus the rule continues to run if a value is found with the get() call.

Nguyen Thanh Tien · Answer

@Chris Rainey  Thank you for your suggestion! Could you please provide more specific guidance on how to implement the IF/ELSE condition after the create lookup table action?

Nguyen Thanh Tien · Answer

@Bill Sheboy It seems the first way meets my need. However the automation isn't working for both scenarios: match and no match (between 'assignee ID' and 'slack user ID'). I've attached the condition I've added. Could you please advise?