vLookup not prefilling values in child

Forums SPJS-Lookup vLookup not prefilling values in child

This topic contains 2 replies, has 2 voices, and was last updated by  Alexander Bautz 6 months, 2 weeks ago.

  • Author
    Posts
  • #23740

    Sarah
    Participant

    Hi again,

    We having another issue with the vLookup where it previously prefilled a specific field in the child and it was working fine. Now the parent list has exceeded the 5000 item threshold and it does not prefill the field anymore.
    Please see attached image about the message when editing the item.

    The field is indexed in the child list. The parent list field is the autogenerated List ID field which is always index as far as I know.

    Any ideas?

    Attachments:
  • #23743

    Sarah
    Participant

    I have found a work around for this issue. As the child list had a Lookup column to the parent list which exceeded the 5000 item limit mark, I created a new column in the child list as set it as text field. Then in the vLookup settings from the parent i set to prefill the new text field with the parent items id. Then I added the new field equals curentitem:id in the query and now it works again.

  • #23752

    Alexander Bautz
    Keymaster

    I’m glad you figured it out. What you have done is also the preferred way to do it if your parent list has potential to exceed 5000 items: https://spjsblog.com/vlookup-for-sharepoint/vlookup-setup-example-for-sp-2010-and-2013/

    Alexander

You must be logged in to reply to this topic.