Nintex Form: Lookup data from another list

[#1]

In short, I want to achieve this - https://walkingthestack.com/2013/11/18/lookup/

So I wish to do a lookup on a list on the same site and pull in a value. The name of the list is Products. It has Title and Price columns.

For the form, I created a drop down lookup field named Product (to represent Items), then I created a calculated column named Price with the formula ("parseLookup("Products", "Id", Product, "Price")"), Qty for quantity then Total (which is Qty times Price).

However, I am getting errors. The "Items" drop down works. The "Price" field shows "#Value!" and the Total shows "ID;#Item" as shown in the below screen grab.

I am seeing a lot of blog posts for older version of Nintex forms shows the formula starting with "lookup" rather then "parseLookup". I've even seen - parseLookup(lookup("MyList","ID", MyDropDownControl, "MyFillInColumn"), true).

Which is correct? What is the best way to use the parseLookup formula in a calculated field?

In short, I want to achieve this - https://walkingthestack.com/2013/11/18/lookup/

[emha · Accepted solution]

lookup() and parseLookup() do two different things.

lookup() effectivelly picks a value from queried list

parseLookup() takes a value of lookup column type (ie in a form: <ID>;#<Title>) and based on true/false parameter it returns either ID or Title part

as for your price lookup you just need to use formula:

lookup("Products", "Id", Product, "Price")

[#3]

Yes, this is correct but this "lookup("Products", "Id", Product, "Price") function work perfectly with SharePoint Server 2013 but not on SharePoint Online until recently 12th of July

[achilles_aditya]

From the same post I created the Lookup on SharePoint Online but didn't check recently. Have u checked the lookup() behavior outside the repeating section or with another list?

[TomaszPoszytek]

Hi!

Don't know whether you have already solved your problem, but lookup should be configured the way described below:

lookup("Products", "Id", Product, "Price")‍

where:

• Products - the name of the list from where you want to get data
• Id - name of the column on which you want to filter (possibly it should be "ID")
• Product - the "Named Control" reference
• Price - the name of the column you want to get in return (I guess it shouldn't be underlined - it should be a plain text).

It is working for me actually

Regards,

Tomasz

[marko]

Hi Tomasz

I do exactly what you describe above in SharePoint Online and I get this warning and an empty calculated field.

 The code on this page disabled back and forward caching. For more information, see: http://go.microsoft.com/fwlink/?LinkID=291337

Any ideas?

[marko]

I get this warning in IE11 and an empty calc field in SharePoint Online
The code on this page disabled back and forward caching. For more information, see: http://go.microsoft.com/fwlink/?LinkID=291337

[mikeboggs]

Does this lookup go in a calculated field? If not, where does it go? 

Edit: never mind. you have to click your named control from the right menu, and not just type it in. That was throwing me off. 

[TomaszPoszytek]

So everything works for everyone, or anyone has still problems with that?

[Riley]

I am getting mixed results on this.  Some of my results are returning "true" instead of the contents of the columns.