--- title: "Lookup List Flows" slug: "lookup-list-data-pair" tags: ["Lookup Lists", "data"] updated: 2025-06-24T19:22:43Z published: 2025-06-24T19:22:43Z 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/v9/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. --- ## What changed from V8 to V9? | Version 8 | Version 9 | | --- | --- | | Lookup Lists were configured at the System level and were visible across the platform. | Lookup Lists are now 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/2025-06-24_13h24_35.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/2025-06-24_13h25_23.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/2025-06-24_13h27_01.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/2025-06-24_13h28_25.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/2025-06-24_13h29_21.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/2025-06-24_13h30_24.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](/v9/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/Screenshot%202024-02-22%20154615.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](/v9/docs/integrate-with-database-table). **![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2025-06-24_15h08_43.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/2025-06-24_15h09_48.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/2025-06-24_15h12_20.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/2025-06-24_15h14_34.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 > Settings > 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/Screenshot%202024-02-22%20154813.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/2025-06-24_15h17_11.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/2025-06-24_15h17_58.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/2025-06-24_15h19_14.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/2025-06-24_15h21_20.png) --- For further information on Flows, visit the [Decisions Forum](https://community.decisions.com/categories/Flows).