Using a concatenated calculated value to perform list lookup

  • 21 September 2017
  • 6 replies
  • 0 views
P
Badge +4

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.)

6 replies

E
Userlevel 5
Badge +14

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‌

P
Badge +4

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

E
Userlevel 5
Badge +14

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

E
Userlevel 5
Badge +14

Hi ‌, did it help?

have you managed to get it working?

P
Badge +4

yes  it did thank you.. :-)

E
Userlevel 5
Badge +14

great!

can you mark correct answer?

‌

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings