Skip to main content
Nintex Community Menu Bar

lookup calculate value item, from the List loockup

  • Jun 5, 2017 3:31 PM UTC
  • 9 replies
  • 25 views
  • Translate All

Forum|alt.badge.img+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

Forum|alt.badge.img+14
  • Scholar
  • Jun 5, 2017 10:39 PM UTC

Forum|alt.badge.img+11
  • Nintex Partner
  • Jun 6, 2017 10:57 AM UTC

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.

Translate

Forum|alt.badge.img+7
  • Author
  • Rookie
  • Jun 6, 2017 9:27 PM UTC

yes, the name of list have space

Translate

Forum|alt.badge.img+7
  • Author
  • Rookie
  • Jun 6, 2017 10:15 PM UTC

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?

Translate

Forum|alt.badge.img+14
  • Scholar
  • Jun 7, 2017 6:34 AM UTC

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

Translate

Forum|alt.badge.img+7
  • Author
  • Rookie
  • Jun 7, 2017 10:48 AM UTC

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>]

Translate

Forum|alt.badge.img+14
  • Scholar
  • Jun 7, 2017 12:16 PM UTC

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?

Translate

Forum|alt.badge.img+7
  • Author
  • Rookie
  • Jun 7, 2017 2:06 PM UTC

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

Translate

Forum|alt.badge.img+7
  • Author
  • Rookie
  • Jun 7, 2017 2:33 PM UTC

Perfect it works
Thanks so much for your support

Translate