jose_fidalgo
Cloud Wanderer

lookup calculate value item, from the List loockup

Jump to solution
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

0 Kudos
Reply
9 Replies
emha
Automation Master
Automation Master

Re: lookup calculate value item, from the List loockup

Jump to solution
Reply
jpmhuls
Workflow Veteran

Re: lookup calculate value item, from the List loockup

Jump to solution

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.

Reply
jose_fidalgo
Cloud Wanderer

Re: lookup calculate value item, from the List loockup

Jump to solution

yes, the name of list have space

0 Kudos
Reply
jose_fidalgo
Cloud Wanderer

Re: lookup calculate value item, from the List loockup

Jump to solution

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?

0 Kudos
Reply
emha
Automation Master
Automation Master

Re: lookup calculate value item, from the List loockup

Jump to solution

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

Reply
jose_fidalgo
Cloud Wanderer

Re: lookup calculate value item, from the List loockup

Jump to solution

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

0 Kudos
Reply
emha
Automation Master
Automation Master

Re: lookup calculate value item, from the List loockup

Jump to solution

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?

View solution in original post

Reply
jose_fidalgo
Cloud Wanderer

Re: lookup calculate value item, from the List loockup

Jump to solution

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

0 Kudos
Reply
jose_fidalgo
Cloud Wanderer

Re: lookup calculate value item, from the List loockup

Jump to solution

Perfect it works
Thanks so much for your support

Reply