List Lookup

Use the List Lookupform control to allow users to select a value from a specified column in a SharePoint list.

For example, if you want to design a form for events and a list of event locations is maintained in a SharePoint Event Locations list. You can create the events form with a lookup control that is connected to the Event Locations list.

Setting	Description
Title	Field title displayed on the published form.
Customize	Switch toggle to Yes to enable customization of the variable Name of the form control.
Name	(This field becomes configurable only when you switch the Customize toggle to Yes.) Customizes the name of the variable A placeholder that stores changes each time the workflow runs, such as the information entered in a form, or the name of a file. You can also create variables to store information you use in the workflow, such as an email address. for the field. If the name is not customized, the Title will be used as the variable name.
Connected to	Connect to a SharePoint column. Only SharePoint columns of the same type as the selected control are available in the drop-down list. When connected, data entered via that field in the form is entered in the selected SharePoint column. What is a SharePoint column? When you open Nintex Forms for a new SharePoint list, the form designer automatically creates form fields for the equivalent SharePoint columns in your list. The SharePoint columns are displayed in the designer when you open it. If you want to delete them from or add them to your form, you can do so under the SharePoint Columns controls.
SharePoint site URL	The URL of the SharePoint site to lookup the value. Enter the URL and click Retrieve lists to retrieve the lists in the SharePoint site and display in the List name drop-down.
List name	The name of the list in the SharePoint site to lookup. The lists available will be automatically populated based on the specified site.
List view	The SharePoint list view to use. With SharePoint list views you can change the way a list appears. For example, you can create a view with a filter that only displays selected items.
List column to display	The column in the SharePoint list to lookup values. The values in this column will be shown in the form field for users to select from.
Display unique values only	Switching toggle to Yes, displays only unique values from the selected SharePoint list column in the form field.
Show all list items	Switching toggle to Yes: Displays all the values from the selected SharePoint list column. Switching toggle to No: Displays items based on the filter condition set in the following fields that are displayed only when the No option is selected. When: The SharePoint column to apply the filter to. Equals value: Type a value for the condition.
Allow multiple values	Switching toggle to Yes, allows the form user to select multiple values in the control.
Display type	The type of format to display the values from the SharePoint list column for users to select from.
Show "Please select"	Switching toggle to Yes, displays "Please select" as default text in the control and as the first item in the drop down list.
Required	Options to make the field a mandatory or optional field in the form. Select from the following options: Yes: Requires entry of value before the form can be submitted. No: Makes the field optional and allows the form to be submitted without an input in this field.
Custom required message	(Displays when you select Yes in Required) The validation text which displays below the field when a value is not entered into the field and the user attempts to change page or submit the form.
Visible	Options to show or hide the field in the form. Yes: Displays the field on the form. No: Hides the field on the form.
Read only	Options to make the field Read-only. Yes: Displays the field on the published form but does not allow user input. No: Allows user input.
Description	A description of the field to display below the field on the published form.
Tooltip	The message which appears when users hover their cursor or touch the information icon beside the field in the form.
Shrink	Reduces the width of the control when placed in a row with other form controls.
Expand	Increases the width of the control when placed in a row with other form controls.