Skip to main content

I have 2 concatenated calculated value fields,  cvaA & cvaAA in List A and a concatenated calculated value field, cvaB, in List B.  In both lists the concatenated values are the same types of information (single line text).  I want to use the value cvaA to lookup in List B to return the value in column SerialNumber.  Is this possible to do?

The user enters values into 2 fields thus the concatenation being done in cvaA of List A.

I have a Lookup defined on the calculated value field - cvaAA :  lookup("Certs", "cvaB", cvaAA, "SerialNumber")

Not working I receive  #value!  on the form.

(List B does have the same values in its concatenated calculated value field for lookup testing.)

yes, this should be possible.

if you get value error, it looks like formula definition/syntax is not correct. check correct spellings/names of list and fields.

is the list being looked up on the same site as the list on which you run the form?

‌ lookup function‌ ‌ ‌ no value returned‌

got it working...    if the lookup does not find any item how can I display a message in the 'value' ?

if(IsNullOrEmpty(lookup(....)),"No Value",lookup(....))

Hi ‌, did it help?

have you managed to get it working?

yes  it did thank you.. :-)

great!

can you mark correct answer?

‌

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings