Configure Lookup for SharePoint > CAML Query Name/Value

Configures the message to show if the lookup does not return any data.

Good to Know

Some information about third-party integrations is outside the scope of the AgilePoint NX Product Documentation, and it is the responsibility of the vendors who create and maintain these technologies to provide this information. This includes specific business uses cases and examples; explanations for third-party concepts; details about the data models and input and output data formats for third-party technologies; and various types of IDs, URL patterns, connection string formats, and other technical information that is specific to the third-party technologies. For more information, refer to Where Can I Find Information and Examples for Third-Party Integrations?

On the Application Explorer screen, do one of these:
- Open an eForm.
- Create an eForm in a Process.
Do one of these:
- Add your form control:
  1. On the eForm Builder screen, in the Toolbox, open one of these tabs:
    - Common Controls
    - Advanced Controls
    - Telerik Controls
  2. On your tab, drag one of these controls onto your form:
    - Auto-Suggest
    - List Box
    - Subform
    - Check Box
    - Auto Lookup
    - List View
    - Pop-Up Select
    - Drop-Down List
    - Auto-Suggest
    - Chart
    - Data Grid
    - Drop-Down List
    - Data Grid
    - Multi-Select List Box
- Change your form control:
  1. On your eForm, click the control, and click Edit .
On the Configure tab, click Add Lookup .
On the Select Data Source Type screen, select SharePoint , and click Next.
On the SharePoint Type screen, select SharePoint Lookup.
On the Lookup Details screen, select Name/Value, and click Next.
On the Configure Lookup screen, click the Error Messages tab.

Field Name	Definition
Site URL	Function: Specifies the URL for your SharePoint site. Accepted Values: A valid SharePoint site URL. Default Value: None Accepts Process Data Variables: Yes Example: http://[machine name]:[port]/sites/[site name] Note: You must include the /sites in the Site URL for the site to be created successfully. Form Based Applications – SharePoint Data Source
Configuration Mode	Function: Specifies how to configure the WHERE clause for the lookup. Accepted Values: Quick Configuration - Lets you quickly create a WHERE clause to configure the lookup. Manual Configuration - Lets you manually create a WHERE clause to configure the lookup. You can select Manual Configuration if you select Multiple Columns in the Lookup Details for SharePoint screen. When you select Manual Configuration, only the CAML Query, Test Query, and Error Messages tabs are available for configuration. Default Value: Quick Configuration
No Items Available	Function: Specifies the error message to show if the lookup does not return any data. Accepted Values: One line of text that can have spaces. Default Value: None
Failure Messages	Function: Specifies the message to show if the data fails to load. Accepted Values: More than one line of text. Default Value: Failed to load data.