Jira Cloud Automation, Lookup table value match a dropdown to a lookup jql issue

Question

Hello, I'm working on an automation that includes sending out Slack Messages to specific channels based on the Team that they're in.

This is the automation that I have done so far:

I have created a Lookup table to have the Teams(Key) webhookURL(value) and have a lookup issue to find these issues with the dropdown of teams. I have then created a for each to cycle through the values of teams that are found in the lookup issue. And have a IF statement to compare the key to the value of teams that are found in the lookup issue and now stuck on making this dynamic and would like some guidance. The screenshots are below;

Any tips and advice would be much appreciated,

Much Thanks!

Bill Sheboy · Answer

Using the Advanced Branch over the distinct values, it would send one message to each team using their URL.  I believe you already have the rule outline.

If it is not working as expected, please post the following to help identify the cause:

* an image of the current, complete rule in one single image
* an image of the Advanced Branch
* an image showing action with the get() call to the Lookup Table

Omar Thompson_m5axvj · Answer

Yeah! That's absolutely correct @Bill Sheboy Thank you for the information, this has seem to do the trick! I do have a question though seem going through the testing will it send a message to each team that is in the key, would I have to duplicate the steps to go through the next stage of teams?

For example if I have 2 teams that has been found will it send a Slack message that has the appropriate webhook url? I wouldn't have to make this step again? Sorry for the misunderstanding. This has absolutely worked though!

Bill Sheboy · Answer

It seems you want to send one message per team with their issues.  Is that correct?

If so, I recommend changing the Advanced Branch to use this smart value.  Please replace customfield_12345 with your field ID.

This will find each unique team value, once per team, using distinct.

Then inside of the branch, use another Lookup Issues action to add the Team check to the earlier JQL, gathering the issues for just that Team.  For example adding this to what you have:

AND "Team Assignment" = "{{teamDropdown}}"

Finally, use the Lookup Table to get the URL for the Slack message:

This is very similar to the scenario of sending one email per assignee.  To see that as an example, please see this knowledgebase article: https://confluence.atlassian.com/jirakb/automation-to-send-email-only-once-per-assignee-1310985609.html