New features in Connected Lookup column
Vladi Gubler
Vladi Gubler
May 18, 2022 | Products


Connected Lookup is the first ever component that we released. Amazingly, we used to have a version of it for SharePoint 2003, at the time when developing custom field types wasn't even supported by the SharePoint platform!

Over the years we've added more and more features to this powerful column type, such as the ability of adding and previewing new items on the fly, sorting, filtering, auto-complete, etc. But the core functionality has always remained the same. What the column is most commonly used for is displaying a lookup, where the options are filtered by another, parent lookup. For instance, a list of subcategories is controlled by the selected category value. It is extremely useful when there are many subcategories available, but only a small subset should be picked from, making data entry simpler, faster and less prone to errors.

Although you could always have multiple levels of lookups filtering each other, each lookup could only have one parent and that parent had to be another lookup in the list. In some scenarios though you might want to have more than one parent, each filtering according to its own parameter.

The current release adds the ability of having multiple parents. Additionally, parent columns can now also be Choice columns, not just Lookups.

Let me start with a simple example. In my list of Sales, I want to select a product based on:

  1. Category - product category, such as Electronics or Dairy. This is a lookup column.
  2. Region - where the product is made, such as Asia or Europe. This one is also a lookup column.
  3. Quality Level - this one is a choice column with values such as A, B and C.

By selecting the desired Category, Region and Quality Level, I'm filtering the list of options in Product to only include the products I really want.

First, let's see how my Products list is defined:

Here too, we have the same columns as in Sales: Category, Region and Quality Level, defining each product. These are regular SharePoint column, nothing special about that.

Back to Sales list, let's go into Ultimate Forms by clicking on Design button, then click on Connected lookup under Columns

Here we will add our Product column and select the following configurations (note that I'm showing an existing column in Edit mode, so Site and List settings are now locked, they cannot be changed for an existing column):

Select the List and Display column, that's easy, next, ensure Filter according to parent lookup is checked. 

Now comes the new part. You can enter more than one Parent column and you can also select Choice columns here, not just Lookups.

Let me explain our terminology a bit:

  • Parent column - another column in the same list (Sales) that will control (filter) the values available in the current column (Product).
  • Relationship column - column in the lookup source list (Products) that specifies the parent column value for each item. So in our Products list we will have a Lookup column for Category that will assign each product to a category (multiple selection is also supported). In case of Choice column, it has to be a Choice column as well.
  • Allow empty - when parent column value is not set, show all values, unfiltered by that parent.

When you configure your own column, you will see additional features, such as the ability to filter and sort by view, add new items, and so on. These are all described in our documentation and are not covered in this blog.

As you can see, although the change is quite small in terms of user interface, it introduces a whole wealth of new and exciting opportunities to build even more advanced solutions for your enterprise!
The feature is now available in both Classic and Modern form in SharePoint Online and will be available on premises in the next release.




Add your comment

Comments are not designed to replace support calls. If you have a specific issue with one of our products, please send an email to to open a support ticket.


Build powerful business applications in SharePoint using only your browser.
100% No-Code Solution

It's never been easier, to create, innovate and share, all you need is your web browser!


Address business process pain points immediately. Save time and money.

Fantastic Support Team

Facing difficulties installing the application? Contact our fantastic support team.

Related Topics

What is right for you?

Online Trial

Not ready to install yet? Create a trial site in our environment
  • Full control of the site and its settings
  • Optionally pre-install one of our solution templates
  • Site provisioned instantly
  • Automatically removed after 30 days
  • Available to everyone!


There was an error processing your request.
Please contact us for further details.


Install in your own environment, on Microsoft 365 and on premises
  • Start working with real users and data
  • Install online or on premises
  • Register for 30 day trial
  • Seemlessly convert to paid license
  • Requires administrator permissions


Download link has been emailed to .
If you do not receive it within 5 minutes, please check your spam.
The link is valid for 72 hours.
If you are having problems, please contact us.


There was an error processing your request.
Please contact us for further details.
Technical details:

Request a Live Demo

Book an appointment for a one-on-one with an ULTIMATEforms expert trainer.

Test drive the awesome power of ULTIMATEforms

Learn how to quickly and easily turn time-consuming business processes into automated, efficient workflows.

Have a strong start

Only thirty minutes of well-coached time can translate into great future savings in time and money. So, sit back and enjoy the ride.

It's Free

Learn how to address business process pain points immediately. Save time and money.