Type As Lookup List

Overview

Lookup Lists are used to search for a specific set of data that can be accessed and used within a Flow or Rule. Lookup Lists are Project specific. 

This article will discuss how to create a Lookup List. To learn more on how to use these in Flows, view the article Lookup List Flows.

Lookup List Categories 

Users can access data created for Lookup Lists from the Flow Designer by expanding each Lookup List's respective Lookup List Category in the Data Explorer tab.

These Categories are created after enabling the Is Lookup List box and providing a name in the Lookup List Category box. The following example subsection demonstrates the location of these settings.

In the event that two or more different Lookup Lists are provided the same Lookup List Category, they will both be placed under the Folder for that specific Category, but separated by Structure Type Name.

Example

1. In the Project, create a Database Structure. 
2. In the Database Structure window, name the structure "CarBrands" and check the Is Lookup List under the Lookup Lists category. Then, provide a name for the Lookup List Category value.
   
3. Select a data field and check the Is Lookup List Key Field checkbox under the ADVANCED category. Then, click SAVE.
   
4. To create records for the database table, right-click on the Data Structure and click Generate a Form. On the dialog window, click GENERATE FORM.
   
5. For the example to work, the Data Structure must have data in it already. Visit Data Structure CRUD Overview to learn how to create a data record.
6. In the Designer Folder, create a Statement Rule. Name the Rule and click CREATE. 
7. Click SETUP INPUT DATA and select DEFINE. Enter "Car" as a name for the Input Data NAME field. Then, click Save and close the window.
   
8. Click Select Data Element. Select Car [String] then Equals for the verb. For the Inputs category, change the input mapping to Select From Flow. Select the Lookup List Category (VehicleData), select a record, and select the Car field.
9. Click DONE to close the window. Then, click Save.
   
   

Debug

1. In the top action panel, click Debug.
2. In the text box under Car, enter the same value previously entered in the Form. In this example, this is "Toyota". Click START DEBUGGING.
   
   The Rule will evaluate as true since the input matches the value in the list from the Data Structure.