Automation - conditional respond based on multiple multi-select fields

[Chris Smith]

Hi all,

I'm a bit stuck with trying to figure out the simplest way to make my idea work, so I'm helping you can all help me.

I have a field that I want to populate with text, based upon the options selected in several multi-select fields.

Specific context: Trying to create an agenda list based on the options selected.

• I have three multi-select list fields: List 1, List 2, List 3
  • These lists are hidden or shown based upon an initial list and scriptrunner
• I have an Agenda rich paragraph field
  • Let's say I select List 1, Option A, the Agenda field should then have * Item 1, *Item 2, etc
  • If I select List 2 Option 3 and 5, the Agenda field should show: *Item 5, Items 6, Items 8, etc

I'm hoping that I can make this work in the Agenda field within automation with a series of IF CONTAINS conditions, but it doesn't seem to be doing anything.
My other option would be to use a ton of IF CONTAINS blocks in my automation and then create variables based on those, but that's not going to be as easy to manage I think, as it would require a lot of blocks to make happen.

I'm not sure if a scriptrunner scripted field might work?

I have some technical/scripting knowledge, but not a ton.

Any help would be greatly appreciated.

[Vishal Biyani · Accepted solution]

@Chris Smith 

if what needs to come in Agenda is well defined can be evaluated based on key value pair, in that case you can check lookup tables and it should simplify the automation rules.

[Chris Smith]

hi @Vishal Biyani and @Bill Sheboy 

Thank you both for the advice about Lookup Tables.

With some help from this question: https://community.atlassian.com/forums/Jira-questions/Combine-multiple-values-selected-in-LookupTable-into-a-field/qaq-p/2923769

I was able to get it working, as I had troubles when I had multiple items selected, and the results weren't pulling through.

[Bill Sheboy · Accepted solution]

Hi @Chris Smith -- Welcome to the Atlassian Community!

Adding to the suggestion from @Vishal Biyani on trying lookup tables, please see this information:

• https://support.atlassian.com/cloud-automation/docs/jira-automation-actions/#Create-lookup-table
• https://community.atlassian.com/forums/Automation-articles/Update-Create-lookup-table-action-improvements/ba-p/2427798

If you have challenges getting this to work for your scenario, please post the following to provide context:

• an image the complete rule in one single image for continuity
• images of the actions creating and using the lookup table
• an image of the audit log details showing the rule execution, with all areas expanded on the right side
• explain what is not working as expected and why you believe that to be the case

Kind regards,
Bill