0

I need to get the LookupId value and the lookup text value by CAML.
With this query I get the ID but I can not get the value text anymore.

<RSSharePointList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <ListName>ListName</ListName>
  <ViewFields>
    <FieldRef Name="Title" />
    <FieldRef Name="MyLookUP" LookupId="true"/>
    <FieldRef Name="MyLookUP" />
  </ViewFields>
</RSSharePointList>

In MyLookUP I have always the ID of the lookup, I wish the value and the ID

  • Can you post entire CAML query? Why do you have MyLookUP field referenced twice? Did you try to omit last FieldRef element and have only one MyLookUP FieldRef element – Slaven Semper Dec 10 '14 at 10:22
  • Is just simple query for a report, I have to group dy Id and display the label of the group (text of the lookup) – Nk SP Dec 10 '14 at 10:24
  • Did you try to omit last FieldRef element and have only one MyLookUP FieldRef element? – Slaven Semper Dec 10 '14 at 10:25
  • yes and I get the id number – Nk SP Dec 10 '14 at 11:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.