lookup calculate value item, from the List loockup

J
Badge +7
I have a "List Lookup" from a list that exists in another site that is associated with the "Rubric" field of the list that I am registering.
The user when selecting an item from the "List Loockup" must fill in a field called "codprojeto".
For this, I am the user loockup function, but it always returns error, when doing an inspect of the page I verify that it does not find the list that corresponds to the "list Loockup".
How I do that?
List Lookup object

Loockup formula from Calculted value

URL SITE:http://domain/finance/Lists/Budgets%20%20Rubrica/AllItems.aspx

9 replies

E
Userlevel 5
Badge +14

have you checked documentation for lookup function?

http://help.nintex.com/en-US/nintex2013/help/#Forms/RootCategory/Designer/Nintex.Forms.LookupFunction.htm%3FTocPath%3DFo… 

203733_pastedImage_0.png

J
Userlevel 2
Badge +11

Does your list title in the formula have 2 spaces between Budgets and Rubrica? The url shows two %20 which is a HTML code for a space.

J
Badge +7

yes, the name of list have space

J
Badge +7

I changed the list name because of the spaces and no longer gives the error of the page.
I can query the sharepoint (CALM), but it still does not return the value of the "Title" field.
The fields are correct and the search value is as well.

Formula: lookup("/finance|Budgets","Description",parseLookup(Rubrica),"Title")

[/finance|Budgets-0ba3c2bc-4f2b-47ac-ac16-b05cd35f6454] - Querying SharePoint for list item data: Query [<View><Query><Where><Eq><FieldRef Name='Description'  /><Value Type='Text'  >Standard cables Extrusion Line</Value></Eq></Where></Query><RowLimit>1000</RowLimit></View>]

Why don´t return nothing?

E
Userlevel 5
Badge +14

- does a user performing lookup has sufficient permissions to the other site and list?

- make sure you do not have any trailing spaces in names (site name, list name, field name ....), they are hard to spot

- try lookup for an item without spaces in description field

- try to convert your lookup as follows

lookup("/finance|Budgets","ID",parseLookup(Rubrica,false),"Title")

J
Badge +7

when put false, return to filter the ID.

I create new formula using trim because the spaces

lookup("/finance|Budgets","Description",trim(parseLookup(Rubrica)),"Title")

But don't works

filter I received:

[/finance|Budgets-19205d39-3d0d-4f6d-bafe-870e0ab27e35] - Querying SharePoint for list item data: Query [<View><Query><Where><Eq><FieldRef Name='Description'  /><Value Type='Text'  >saddasdsadsdasd</Value></Eq></Where></Query><RowLimit>1000</RowLimit></View>]

E
Userlevel 5
Badge +14

when put false, return to filter the ID.

yes, that's the point, to compare by unique ID and not by text. lookup by ID is much more reliable.

I would strongly recommend to make lookup by ID.

have you checked first two hints as well?

J
Badge +7

Yes I checked, i have permissions and not have any spaces.

J
Badge +7

Perfect it works
Thanks so much for your support

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings