Is it possible to use two lookup objects in a single automation?

[Tim Kennett]

Hi everyone, 

I'd like to lookup two values from different areas of a schema from our asset DB but I'm finding it difficult to figure out how to do this? 

Is this even possible? 

I can do it once but not twice as the second overrides the previous entry. 

I just want to put the two values into an email. 

I'm sure theirs a better way of doing this. 

[Bill Sheboy · Accepted solution]

Hi @Tim Kennett 

First, a disclaimer: I am not currently using assets and so cannot test this suggestion, although it definitely works with Lookup Issues...

The Create Lookup Table action can preserve the typing / structure of smart value objects (unlike the Create Variable action which always produces text).

And so try this:

• action: Lookup Objects
• action Create Lookup Table
  • name: varFirstLookup
  • row
    • key: first
    • value: {{lookupObjects}}
• action: Lookup Objects, with different criteria...
• something that needs both
  • use {{varFirstLookup.get("first")}} to access the first one
  • use {{lookupObjects}} for the second one

Kind regards,
Bill

[Benjamin]

Hi @Tim Kennett ,

There's a few options that you can take but none are direct:

• Create 2 rules and send two emails
• Depending on your lookup. Perhaps you can combine into one lookup.
• Store your lookup values as multiple variables

See this similar for further details

https://community.atlassian.com/forums/Automation-questions/LookupIssue-Is-there-a-way-to-have-2-result-set-in-one-email/qaq-p/1446540

Hope this helps.