Lookup Field from Large List

Discussions about Forms Designer for SharePoint 2013 / 2016 and Office 365.
Locked
YumaIT
Posts: 18
Joined: Tue Oct 02, 2018

07 Oct 2018

Hi,
I am trying to create a lookup field on a form that is pulling from a large list that exceeds the threshold limit. This look up field is from the parent entity (Tickets). Our system allows child entities (Actions) to be created unattached to the parent, and then linked to the parent before closing.

See attached example where I have a Action record (child entity) that I am trying to associate with a Ticket (parent entity). The ticket list is very large but I have several fields which I can filter on.

I would like to know if there is a way that we can filter the drop down based upon a combination of fields in the parent list. The fields I would use are Client and Status. Client would be available on the Action edit form selected by the User. Status would be something we would set as a default to only show our version of "active" Tickets.
Attachments
ThresholdLimit.PNG
ThresholdLimit.PNG (36.16 KiB) Viewed 2090 times

User avatar
AlexZver
Posts: 232
Joined: Mon Aug 27, 2018

08 Oct 2018

Hi!

Sure, there are already a fair number of examples on this topic, please visit https://spform.com/category/cross-site-lookup.

Let me know if you have any further questions on this matter.

YumaIT
Posts: 18
Joined: Tue Oct 02, 2018

09 Oct 2018

Alex,

Just making sure; we would need to go ahead and purchase/implement the Cross-Site-Lookup component to make this work, correct? The lists are all in the same site, but there is functionality built-into the Cross-Site-Lookup component that would make the process easier, right?

Thanks for your help, you guys are great!

User avatar
AlexZver
Posts: 232
Joined: Mon Aug 27, 2018

10 Oct 2018

Hi!

Yes, the Cross-site Lookup functionality will make the solution much easier, you can get a free trial to try it: https://spform.com/download

Helpful links:
https://spform.com/cross-site-lookup/cr ... 5000-items
https://spform.com/cross-site-lookup/us ... hold-limit

Locked
  • Information
  • Who is online

    Users browsing this forum: No registered users and 20 guests