Custom CAML query in vLookup to avoid LVT needs parameter

Home › Forums › vLooup for SharePoint › Custom CAML query in vLookup to avoid LVT needs parameter

Tagged: 

Viewing 0 reply threads
  • Author
    Posts
    • January 27, 2015 at 22:22 #6963
      Keith Hudson
      Participant

        I was struggling using vlookup against a list that exceeded the LVT and my custom CAML was not working until Alex told me I need to use a <Where> parameter in my CAML, like this: <Where><Eq><FieldRef Name=’ITRID’ /><Value Type=’Text’>[currentItem:ITRID]</Value></Eq></Where>.

        Its now working as expected. Posting this in case anyone else runs into the issue.

        Strangely, using the “Build Query” section threw a LVT error, but building the same query using the “Write your own CAML-query” section did not.

    • Author
      Posts
    Viewing 0 reply threads
    • You must be logged in to reply to this topic.