I have this query:

        <FieldRef Name='Title' />
        <FieldRef Name='itlgCategoria'/>

itlgCategoria is a lookup field

When I use CAML query Builder i get this:

enter image description here

My list have 2 rows.

If I try to get the ID from lookup field (Conexao.oList.get_item('itlgCategorias').get_lookupID();) i have the output: ;


But if I try to get the Value (Conexao.oList.get_item('itlgCategorias').get_lookupValue();) from lookup field i have the output:


I need to get Achados e Perdidos and Campanhas

What I'm doing wrong?

  • Is this people and group column?
    – Aanchal
    Sep 29, 2014 at 15:03
  • No. Custom category column. Category list have only one displayed column: Title, and I need to get this value.
    – Joao Paulo
    Sep 29, 2014 at 15:04
  • In your lookup column settings (in list settings) what does it say under 'In this column:' ? Title or ID?
    – John-M
    Oct 1, 2014 at 13:55

1 Answer 1


I found the error.

My list only have the ID information.

Sharepoint understand that the value information is in the other list that I didnt have permission to read in my App.

When I added "Web" permission in my AppManifest file, sharepoint allows me to access the Value of lookup column.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.