I am attempting to retrieve a value based on a selection the user has made in a Lookup dropdown. The output value I want is stored in a lookup column.
lookup("Impacts","Title",parselookup((Form]..lookupAppSystem]),"BSA")
In plain terms: In the "Impacts" list, return the value from the "BSA" column where the "Title" equals the value selected in the "lookupAppSystem" dropdown.
This formula works just fine if the column I am retrieving the value from is not a lookup column. But the formula does not work if the output value is from a lookup column, no value is returned and I get a blank value. Is this a limitation of Nintex? How can I workaround this?