Contact us
View as Markdown
Ask AI

Open this page in an AI assistant with a ready-made prompt.

Opens a third-party service and shares a pre-filled prompt containing this public page URL, its product documentation URL and /llms.txt. No VirtoSoftware account or tenant data is included. Provider terms and privacy policies apply. Verify answers against the linked documentation.

OpenAI terms · OpenAI privacy policy · Anthropic terms · Anthropic privacy policy

Using Lookups for Data Reference

Go to the SharePoint list where you have adjusted Virto Cross-Site Lookup Selector columns and click “new item”.

Equipment Requests list in the classic view with the Category and Items cross-site lookup columns and the new item link

For a column with a single value, choose the value in the drop-down list. A dependent column offers only the values that match the column it depends on.

Start typing in the field to find a value: the list shows the matching values as you type, or “No matches”. In a single-value column the search finds the values that contain the typed text, regardless of case. Use * for any characters and ? for one character. Up to 50 matches are shown; type more letters to narrow the list.

Each value in the list shows the Display Column value followed by the values of the fields selected in Show other columns, separated by commas. The values are sorted alphabetically. A column that does not require a value offers “(None)” as the first option to leave it empty.

New item form with Country set to Germany and “mu” typed in the dependent City column, which offers Munich

In the example below, the Items column allows multiple values and depends on the Category column: after you choose a category, only the items of that category are offered. Each item shows its price, a field selected in Show other columns.

For a column that allows multiple values, type in the search box above the list of available values to narrow the list, select the values and click Add >. The search box finds the values that contain the typed text, regardless of case.

Items column with “inch” typed in the search box: the available values are narrowed to Laptop 14-inch and Monitor 27-inch

Select a value and click Add >; < Remove returns a chosen value to the list.

Items column after clicking Add: Docking station and Monitor 27-inch are in the list of chosen values

Click “Save” to create the item.

If a column that requires a value is empty, the form is not saved and shows the standard SharePoint message “You must specify a value for this required field.”

You can view the list item to see the details. On the item display form, every value is a link to the source item.

Item display form with the Category value IT equipment and the Items values Docking station and Laptop 14-inch shown as links

The values of the fields selected in Show other columns are shown next to each value in the list of values on the New and Edit forms and in classic list views.

Show other columns block with the Address and Phone fields added

This way you can create lookups and set references between SharePoint list columns.

Updated on November 12, 2026