Iterating over smart value and lookup table

[Giedrius Daugmaudis]

I'm creating automation, that would look at form submitted, and would provide groups based on selections ( may be multiple).

But I'm getting errors when iterating
"Failed to get value for adGroups.get(.): {{#env.split(", ")}}{{adGroups.get(.)}}{{/}}"

I know that lookup objects/tables have values.
Looks like the iteration is converting string into something else?
Or am I calling the iterated object wrong in this case? 

[Bill Sheboy · Accepted solution]

Hi @Giedrius Daugmaudis 

For a question like this, context is important for the community to help.  Please post the following:

• describe the problem your rule is trying to solve; that is, "why do this?"
• an image of your complete automation rule in a single image for continuity
• images of any relevant actions / conditions / branches
• an image of the complete audit log details showing the rule execution

Until we see those...

Your rule appears to be using a lookup table / objects action to gather some data, and then you are trying to access that table within a long-format iterator over a list using the table's get() function.  That will not work.

Long-format iterators can only access data from that scope and lower.  Thus, your table data cannot be seen to use the implied {{.}} list element as a parameter.  (And, even if that worked, there is another old defect where long-format iterators calling a function with a parameter will always pass the first item and not any others.)

Without seeing your entire rule for context, I suspect you will need to use some form of dynamic list searching with regular expressions as I describe in this article:

https://community.atlassian.com/forums/Automation-articles/Automation-concepts-Dynamic-searches-within-a-list/ba-p/2834235

If you post the requested information from above, that may help the community offer additional suggestions.  Thanks!

Kind regards,
Bill

[Giedrius Daugmaudis]

What I'm aiming for is dynamic group selection, based on form selections.
Application list always changes, so we cannot expect to update form manually.

Form

APP - Multiselect field (App1; App2)
ENV - Multiselect field (Prd; Acc; Sys)

Supporting assets

• App1
  
  • groups
    
    • Prd: string
    • Acc: string2
    • Sys: string3

Sounds like I need to embrace the limitations here.
Solved it by doing something I don't like - created variables for each potential environment, then group them together and removed first symbol to have somewhat usable string.

Would have loved dynamic iteration working, but it is what it is.

[Giedrius Daugmaudis]

This did the.. trick.. 

{{#if(adGroupsString.endsWith(";"))}}
{{adGroupsString.substring(0,adGroupsString.length().minus(1))}}{{/}}
{{#if(not(adGroupsString.endsWith(";")))}}
{{adGroupsString}}{{/}}