cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Using a concatenated calculated value to perform list lookup

Jump to solution

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

Labels: (2)
0 Kudos
Reply
6 Replies
Workflow Hero

Re: Using a concatenated calculated value to perform list lookup

Jump to solution

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‌

Reply
Workflow Hero

Re: Using a concatenated calculated value to perform list lookup

Jump to solution

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

Reply
Workflow Hero

Re: Using a concatenated calculated value to perform list lookup

Jump to solution

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

Reply
Workflow Hero

Re: Using a concatenated calculated value to perform list lookup

Jump to solution

Hi ‌, did it help?

have you managed to get it working?

Reply
Workflow Hero

Re: Using a concatenated calculated value to perform list lookup

Jump to solution

yes  it did thank you.. :-)

Reply
Workflow Hero

Re: Using a concatenated calculated value to perform list lookup

Jump to solution

great!

can you mark correct answer?

0 Kudos
Reply