--- title: "Lookup List Flows" slug: "lookup-list-data-pair" description: "Learn how to create Project-level Lookup Lists in Decisions and retrieve data by key for use in Flows and Rules as Data Pairs, DynamicDataRows, or objects." updated: 2026-07-02T21:00:27Z published: 2026-07-02T21:00:27Z canonical: "documentation.decisions.com/lookup-list-data-pair" --- > ## Documentation Index > Fetch the complete documentation index at: https://documentation.decisions.com/llms.txt > Use this file to discover all available pages before exploring further. # Lookup List Flows ## Overview [**Lookup Lists**](https://documentation.decisions.com/version-10/docs/type-lookup-list) are used to search for a specific set of data (typically within a Database Table) that can be accessed and used within a Flow or Rule. The Lookup List feature allows users to create specific System Constants and obtain the value of an object using a defined key. This value can be output as either a **Data** **Pair**, a **DynamicDataRow**, or an **Object**, depending on the type of Lookup List Flow they originate from. In **v9** and above, Lookup Lists are Project-level and are visible only within the Project. --- ## Data Pair The following example will demonstrate how to create a Lookup List Flow that will fetch all accounts, map them to a List Mapping step and output the Lookup List. 1. Navigate to **Projects > Desired Project > Settings > Configuration > Variables > Lookup Lists.** Click ADD LOOKUP LIST FLOW and select **Lookup List Flow (Data Pair)** from the top action bar; name the Flow, then click **CREATE**.![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1783025974470.png) 2. Attach a **Fetch Entities** step from the **DATABASE ENTITY** category of the **Toolbox** panel to the Done path of the **Start** step. On the **Properties** panel, enter "account" in the **Type Name** dropdown box and select **Account**.![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1778765148261.png) 3. Attach a **List Mapping Step** from the **DATA > LIST** category to the **Results** path of the Fetch Entities step. Connect the **No** **Results** path to the **End** step. 4. On the Properties panel, map **EntityResults** to the **INPUTS** field. In the **Output Type** dropdown menu, search for and select **DataPair.** Click **Show Item Mapping Editor**.![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1778765370316.png) 5. Set the mapping for **ITEM** to **Build** **Data**. Expand **_INPUT** and connect **EmailAddress** to **Name** and **AccountID** to **OutputValue**. Click **OK.**![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1778765459275.png) 6. Connect the Done path to the **End** step. On the Properties panel, map **OUTPUTS** to the **List** **Data** field. Click **Save** to save the changes to the Flow.![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1778765693929.png) 7. Click **Debug** from the top action bar. Click **START DEBUGGING.** 8. After the Flow runs, view the Input data for the End step. The End step's inputs will display a DataPair for each AccountID and its corresponding Email.  ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1778765739714.png) --- ## Data Row The following example will demonstrate how to create a Lookup List Flow (Data Row) that will output a DynamicDataRow from a row in the Account Database Table. This example integrates with a [Database Table](/version-10/docs/integrate-with-database-table). 1. In the platform, navigate to **Projects > Desired Project > Settings > Configuration > Variables > Lookup Lists****.** Click **ADD LOOKUP LIST FLOW** and select **Lookup List Flow (Data Row)**. Provide a Name and click **CREATE.**![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1783025998861.png) 2. Attach a **Get all from dbo.abstract_defined_case** step to the **Start** step by navigating in the **Toolbox** panel to **INTEGRATION > DATABASE > LOCAL CONNECTION > DBO.ABSTRACT_DEFINED.** These steps are only available after [Integrating with a Database Table](/version-10/docs/integrate-with-database-table). **![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1778767050530.png)** 3. From the **Properties panel,** under the **OUTPUT SETTINGS** category, select **Data Rows** for the **Return Data Option** field. Select **Constant** map for the **Limit Count** field and enter "10".  The Limit count input is used to limit the number of data returns.  ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1778767107789.png) 4. Connect both the **Done** and **Failed** paths to the **End** step. Then select the End step to navigate to its Properties tab. **Select From Flow** map **abstract_defined_case_Result.Last to INPUTS > Output Row**.![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1778767224389.png) 5. Click **Save** to save the Flow. 6. Click **Debug**. Click **START DEBUGGING.** 7. After the debugger runs, select the **End step > Execution 1 > View Output Data** to view the Output DynamicDataRow. The resulting **OutputRow** for this example reflects the 10th row within the **Accounts** **Database**.   ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1778767271633.png) --- ## Object The following example will demonstrate how to use the Lookup List Flow (Object) to output an Account object from the dbo.entity_account Table. 1. From the Decisions Studio, navigate to **Projects > Desired Project > Manage > Configuration > Variables > Lookup Lists****.** Click **ADD LOOKUP LIST FLOW** and select **Lookup List Flow (Object)**. Name the Flow and click **CREATE.**![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1783026020561.png) 2. Attach a **Get all from dbo.abstract_defined_case** step from the **Toolbox** panel by navigating to **INTEGRATION > DATABASE > LOCAL CONNECTION > dbo.abstract_defined_case** to the **Start** step.![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1782486620697.png) 3. From the **Properties** panel, enter "account" in the **Output Type** field and select **Account**. Enter "4" in the **Limit count** field.![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1778767946790.png) 4. Connect the **Done** and **Failed** paths to the **End** step. Select the End step and select the Select From Flow mapping for Output Object. Select **abstract_defined_case****_Result** and click **DONE.**![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1778767995873.png) 5. Click **Save** to save the Flow. 6. Click **Debug**. Click **START DEBUGGING.** 7. After the debugger runs, select **End step > Execution 1 > View Output Data** to verify the **Output** results. As the Limit count on the Get all step was set to 4, the resulting **Output** will reflect the first four Account **Objects** from the Account Database Table.  ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1778768020441.png)