---
author_name: Aviral Agarwal
author_profile: https://github.com/aviral-agarwal-sap
keywords: tutorial
auto_validation: true
time: 20
tags: [ tutorial>beginner, software-product>sap-business-technology-platform, tutorial>free-tier]
primary_tag: software-product>sap-build-process-automation
parser: v2
slug: spa-dropdown-value-help-filtering
canonical_url: https://developers.sap.com/tutorials/spa-dropdown-value-help-filtering
---

# Connect Action Project to Dropdown in Form
<!-- description --> Use and add a data source to the form dropdown field in order to display information from external systems

## Prerequisites
- Complete the tutorial [Create Business Partner Action Project in SAP Build Actions](spa-business-partner-action-create)

## You will learn
- How to use action project to retrieve data from data source and show in dropdown in form

## Intro
In this tutorial, you will create a project using a template from the store and edit the trigger form to create a dropdown and populate it with the values from the action project.

### Import sample process as template

1.  From the **SAP Build** lobby, select the **Store** tab.

    ![Import Project](https://raw.githubusercontent.com/sap-tutorials/sap-build-process-automation/main/tutorials/spa-dropdown-value-help-filtering/ImportProject_31.png)

2. On the **Store** page, search for **Sales Order Management (MI01)** and once it loads, click **Create from Template**.

    ![Import Project](https://raw.githubusercontent.com/sap-tutorials/sap-build-process-automation/main/tutorials/spa-dropdown-value-help-filtering/ImportProject_32.png)

3. In the **Project Name** field, enter **Sales Order Approvals Project**.
   
    > You can keep the default description or enter the description of your choice

    - Click **Create**.

    ![Import Project](https://raw.githubusercontent.com/sap-tutorials/sap-build-process-automation/main/tutorials/spa-dropdown-value-help-filtering/ImportProject_33.png)

4. Open **Lobby** and you will see your project created.
   
5. Click on the **Sales Order Approvals Project** to open it.

    ![Import Project](https://raw.githubusercontent.com/sap-tutorials/sap-build-process-automation/main/tutorials/spa-dropdown-value-help-filtering/ImportProject_34.png)


### Create a dropdown in order processing form


1.  Select the **Order Processing Form**.

    ![Action Project](https://raw.githubusercontent.com/sap-tutorials/sap-build-process-automation/main/tutorials/spa-dropdown-value-help-filtering/005.png)

2. Select the menu for the **Customer Name** text field and select **Delete**.

    ![Action Project](https://raw.githubusercontent.com/sap-tutorials/sap-build-process-automation/main/tutorials/spa-dropdown-value-help-filtering/006.png)

    You will now replace the text field with a dropdown field.

3. Drag and drop a **Dropdown** field in the form and enter the name as **Customer Name**.
   
4. Check the required box on the right side panel.
   
5. Choose **save**.

    ![Action Project](https://raw.githubusercontent.com/sap-tutorials/sap-build-process-automation/main/tutorials/spa-dropdown-value-help-filtering/007.png)


### Add environment variable to access destination

1. Select the **Settings** icon at the top-right corner.

    ![Action Project](https://raw.githubusercontent.com/sap-tutorials/sap-build-process-automation/main/tutorials/spa-dropdown-value-help-filtering/009.png)

2. In the **Project Properties** pop-up, select **Environment Variables** and choose **+ Create**.

    ![Action Project](https://raw.githubusercontent.com/sap-tutorials/sap-build-process-automation/main/tutorials/spa-dropdown-value-help-filtering/010.png)

3. Fill in the information:

    - Enter `S4_Business_Partner` as identifier.
    - Enter **Description** of your choice.
    - Select the **Type** as **Destination**.
    - Choose **Create**.

    ![Action Project](https://raw.githubusercontent.com/sap-tutorials/sap-build-process-automation/main/tutorials/spa-dropdown-value-help-filtering/011.png)

4. Once the environment variable is created, close the pop-up.

    ![Action Project](https://raw.githubusercontent.com/sap-tutorials/sap-build-process-automation/main/tutorials/spa-dropdown-value-help-filtering/012.png)


### Add action project to dropdown

1. Select the **Customer Name** dropdown.
   
2. As **Data to display**, choose **Data Source**.
   
3. Select the value-help option for **Data Source** field.

    ![Action Project](https://raw.githubusercontent.com/sap-tutorials/sap-build-process-automation/main/tutorials/spa-dropdown-value-help-filtering/008.png)

4. In the **Browse Library** pop-up, choose **GET** as **Action Type**. 
   
5. Select the **Add** option for the action project you created earlier.

    ![Action Project](https://raw.githubusercontent.com/sap-tutorials/sap-build-process-automation/main/tutorials/spa-dropdown-value-help-filtering/013.png)

    > **CAUTION:** The action project will only be visible in the Browse Library pop-up if the Main Output Array is marked in the action response as described in previous tutorial.

6. Select the `S4_Business_Partner` as the **Destination Variable** and select the value-help option for **Available Data** field.

    ![Action Project](https://raw.githubusercontent.com/sap-tutorials/sap-build-process-automation/main/tutorials/spa-dropdown-value-help-filtering/014.png)

7. Choose the **Customer Name** option from the dropdown.

    ![Action Project](https://raw.githubusercontent.com/sap-tutorials/sap-build-process-automation/main/tutorials/spa-dropdown-value-help-filtering/015.png)

8. **Save** the form.

    ![Action Project](https://raw.githubusercontent.com/sap-tutorials/sap-build-process-automation/main/tutorials/spa-dropdown-value-help-filtering/016.png)

    With this, you have created a form with dropdown as input field and connected your action project to the dropdown.
