sgrams
Scholar

Return value from Lookup Column using the 'lookup' formula

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?

0 Kudos
Reply
1 Reply
sgrams
Scholar

Re: Return value from Lookup Column using the 'lookup' formula

I should have mentioned that "BSA" is the lookup column in the "Impacts" list, though maybe that was already obvious.
0 Kudos
Reply