How to connect lists with SharePoint Related Items Field Type feature

⌘K
  1. Home
  2. Docs
  3. Virto Related Items Field...
  4. VIRTO SHAREPOINT RELATED ...
  5. How to connect lists with SharePoint Related Items Field Type feature

How to connect lists with SharePoint Related Items Field Type feature

When you have installed Virto SharePoint Related Items Field Type and activated it, you need to adjust the feature.

Since Virto SharePoint Related Items Field Type is supposed to work with SharePoint lists of current site collection, you have to:

  • create a list you are going to work with, add lookup column and adjust the feature or
  • add a lookup column to an existing list and adjust the feature.

For example, you need to aggregate information from distinct personal lists (eg. “John’s expenses”) in one list of employee’s expenses (“Expenses”).

how_to_connect_lists_with_sharepoint_related_items_field_type_feature_1

Every child list should have the lookup column pointed to the parent list “Expenses”. The following example contains the lookup in “John’s expenses” list:

how_to_connect_lists_with_sharepoint_related_items_field_type_feature_2

The parent list “Expenses” should contain “Virtosoftware Related items” columns pointed to all child lists.

On the following picture, I have created in parent “Expenses” list a new “Virtosoftware Related items” column named “John”.

how_to_connect_lists_with_sharepoint_related_items_field_type_feature_3

Scroll down to the bottom of column creation form to the “Related Items Definition” settings.

Select the child list, a linked lookup column and define other options if needed (see the next chapter for more details).

The default settings look like follows:

how_to_connect_lists_with_sharepoint_related_items_field_type_feature_4

Save the column.

Now, the column “John” in list “Expenses” represents the personal expenses from child column.

how_to_connect_lists_with_sharepoint_related_items_field_type_feature_5

How can we help?