vLookup to document library over 5k items

Forums Classic DFFS vLookup to document library over 5k items

Viewing 2 reply threads
  • Author
    • #37578
      Jonathan Stamper

      I have a vlookup connection to a document library (I have old forum questions about set up back in 2021-2022). The library has hit over the 5000 item view limit causing the vlookup portion on the main form to show a DEBUG/Error message and not the vlookup table. Now, I said to offload as much as possible but was curious if there are ways around that limit using vlookup?

    • #37580
      Alexander Bautz

      Yes, this should be an easy fix. You must open the list settings on your document library and index the field you use in your vLookup filter query (_vLookupParentIDif you followed the setup example). When this is done, your vLookup should be back in working order.

      Please let me know if you have any further questions.

      Best regards,

    • #37581
      Jonathan Stamper

      I knew it was probably something that but wanted to check. Thank you.

Viewing 2 reply threads
  • You must be logged in to reply to this topic.