Power Apps Dropdown Control – How to Use

In this Power Apps tutorial, I will explain how to use the Power Apps dropdown control with various properties of Power Apps dropdown control.

I will show you how to add a dropdown control to a Power Apps canvas app, how to add items manually to a dropdown control in Power Apps, and, finally, how to populate a dropdown list from a SharePoint list in Power Apps.

In the end, we will see how to save the selected value from the Power Apps dropdown to a SharePoint list and how to validate a Power Apps Dropdown control.

Power Apps Dropdown Control

Power Apps dropdown control helps users select a single item from various choices. The dropdown can show a maximum of only 500 items; if it is more than 500, it shows a message that it has reached the maximum limit.

Power Apps dropdown control

By default, “AllowEmptySelection” is false unless the user sets it to true.

Power Apps Dropdown Control Properties

In this section, I will explain all the properties of the Power Apps dropdown control:

Property NameDescription
AccessibleLabelThis property is assigned to a screen reader label.
AllowEmptySelection This property explains the condition in which no item is selected, the control displays an empty selection. Users may also clear their selections by choosing the blank item.
Border ColorA user can specify the color for a border.
Border StyleThis property specifies the type of border that the control should have [“Solid”, “Dashed”, “Dotted”, “None”].
ChevronHoverBackgroundUsers can specify the background color for a chevron.
DefaultWhen the user opens the app, by default the item should be selected. For this, we can specify a single item to the dropdown Default property.
Fill This property displays the background color of the control.
ItemsTo represent the values in a dropdown, we can specify the data source along with the column name, else we can provide it manually.
OnChangeWhen the user changes a selection, it specifies what action to perform.
OnSelectWhen the user clicks on a control, it specifies what action to perform.
ResetWe can reset the dropdown selected value to its default value or blank.
TabIndexThis refers to the keyboard navigation sequence that is related to other controls.
VisibleHere, we can specify whether the dropdown control can be visible or not.

How to add Power Apps Dropdown control

Here, let me show you how to insert a dropdown control on the Power Apps screen. If you are new to Power Apps, check out a tutorial on Create a Canvas App from a SharePoint List.

  • Sign in to your Power Apps with your valid Microsoft 365 credentials.
  • Create a Blank canvas app -> On the Power Apps screen, insert a Dropdown control [Click on +Insert -> Expand Input -> Select Dropdown]
How to add Power Apps dropdown control

The dropdown control will appear like the screenshot below.

Dropdown control in Power Apps
  • By default, the dropdown control name will be “Dropdown1“; it is always better to provide a meaningful name.
How to use Power Apps dropdown control

This is how to insert a Power Apps dropdown control. Then, let us see how to add items to the above dropdown list.

Add items to the Power Apps dropdown control

Power Apps allows us to manually add items to a dropdown control and from other sources like SharePoint, Excel, Collections, etc.

So, let us check how to bind values to a Power Apps dropdown manually and from a SharePoint list.

1. Power Apps dropdown add items manually

Here, I will show you how to add items manually in the Power Apps dropdown control.

  • On the Power Apps screen, insert a Dropdown control -> Set its Items property to:
["Outlook","Laptop","Network","Other"]
Add Power Apps dropdown control
  • SavePublish, and Preview the app. Now, the dropdown control contains the items that we added manually.
Dropdown modern control in Power Apps

This is how to add items manually in the Power Apps dropdown control.

Populate Power Apps dropdown items from a SharePoint list

Here, I will explain how to bind the dropdown values using a SharePoint list as a data source in Power Apps.

For this, I have a SharePoint list [Deaprtment], with a column below:

Column NameData Type
Department Title
Bind the Power Apps dropdown value

We will bind the above list Title column values to a Power Apps dropdown control like the screenshot below.

Power Apps bind dropdown values

To work around this example, create a blank canvas app by using the SharePoint list and follow the below steps:

  • On the Power Apps screen, insert a Dropdown control -> Set its Items property to:
Distinct('Customer Details',Title)

Where,

  1. Customer Details = SharePoint list name
  2. Title = SharePoint list title column
How to create drop down list in sharepoint list
  • SavePublish, and Preview the app. Now, you can see the dropdown control contains the values from the above SharePoint list title column.
How to bind dropdown values from SharePoint list

This is how to bind items to a Power Apps dropdown control from a SharePoint list.

How to Bind Power Apps Dropdown Items From Collection [Manually]

Here, I will show you how to bind the Power Apps dropdown items from a collection [Manually].

Example:

  • In Power Apps, there is a Dropdown control and a Data table. The dropdown control contains the collection items.
  • When a user selects a value [let’s say May] from the dropdown control, the data table filters and displays the corresponding record based on the selected dropdown value.
Power Apps dropdown items from collection

To achieve it, follow the below steps:

  • Create a Power Apps collection on the screen OnVisible property:
OnVisible  = ClearCollect(
    colBudget,
    {
        'Month': "January",
        'Estimated Expenditure': "$237",
        'Description': "Development Phase 1",
        'Actual Expenditure': "$300"
    },
    {
        'Month': "Febrauary",
        'Estimated Expenditure': "$137",
        'Description': "Development Phase 2.1",
        'Actual Expenditure': "$210"
    },
    {
        'Month': "March",
        'Estimated Expenditure': "$98",
        'Description': "Development Phase 2.4",
        'Actual Expenditure': "$100"
    },
    {
        'Month': "April",
        'Estimated Expenditure': "$300",
        'Description': "Development Phase 2.8",
        'Actual Expenditure': "$300"
    },
    {
        'Month': "May",
        'Estimated Expenditure': "$80",
        'Description': "Development Phase 3",
        'Actual Expenditure': "$90"
    },
    {
        'Month': "June",
        'Estimated Expenditure': "$200",
        'Description': "Development Phase 3.8",
        'Actual Expenditure': "$300"
    },
    {
        'Month': "July",
        'Estimated Expenditure': "$400",
        'Description': "Development Phase 4",
        'Actual Expenditure': "$300"
    },
    {
        'Month': "August",
        'Estimated Expenditure': "$150",
        'Description': "Development Phase 4.1",
        'Actual Expenditure': "$200"
    });

Where.

  1. colBudget = Collection Name
  2. ‘Month’, ‘Estimated Expenditure’, ‘Description’, ‘Actual Expenditure’ = Collection Headers
Dropdown items from collection in Power Apps
  • Insert dropdown control -> Set its Items property to:
Items = Distinct(colBudget,Month)

Where,

  1. colBudget = Collection name
  2. Month = Particular collection column name
How to Bind Power Apps Dropdown Items From Collection
  • Insert a Data table control and set its Items property to the code below:
Items = Filter(
    colBudget,
    Month = drp_Month.Selected.Value
)

Where,

  1. colBudget = Collection name
  2. Month = Particular collection column name
  3. drp_Month = Dropdown control name
How to bind Power Apps dropdown items from the collection
  • Save, Publish, and Preview the app. By selecting a value from the dropdown control, the data table will automatically filter and display the corresponding record.
Bind dropdown items from collection in Power Apps

This is how to bind the Power Apps dropdown items from the collection [Manually].

Bind Power Apps Dropdown Items From Collection [Using SharePoint list]

In this section, let’s see how to bind the Power Apps dropdown items from the collection [Using SharePoint list].

Example:

  • I have a SharePoint list [IT Request List], which has various columns like:
Column NameData Type
IssueTitle
StatusChoice [“Completed”, “Ongoing”, “Cancelled”]
Issue Raised ByPerson or group
Issue Handled ByLookup
Power Apps dropdown items from a collection
  • In Power Apps, there is a Dropdown control and a Gallery control. The dropdown control contains the values from the SharePoint choice column.
  • When a user selects a value from the dropdown control, the data table filters and displays the corresponding record based on the dropdown choice value.
Bind Power Apps dropdown items from the collection

Follow the below steps to achieve it:

OnStart = ClearCollect(colDetails,'IT Request List')

Where,

  1. colDetails = Collection name
  2. IT Request List = SharePoint list name
Dropdown items from collection in a Power Apps
  • Insert Dropdown control and set its Items property to:
Items = Distinct(colDetails,'Status '.Value)

Where,

  1. colDetails = Collection name
  2. Status = SharePoint list choice column name
How to bind dropdown items from collection in Power Apps
  • Insert a Gallery control and set its Items property to:
Items = Filter(
    colDetails,
    Status.Value = drp_Status.Selected.Value
)

Where,

  1. colDetails = Collection name
  2. Status = SharePoint list choice column name
  3. drp_Status = Dropdown control name
Power Apps bind dropdown items from a collection
  • Now, run the Run Onstart app. Save, Publish, and Preview the app. By selecting a value from the dropdown control, the gallery will automatically filter and display the corresponding record based on the dropdown selected value.
How to bind Power Apps dropdown items from a collection

This is how to work with Power Apps dropdown items from the collection [Using SharePoint list].

Power Apps save dropdown selected value to a SharePoint list

In this section, I will explain how to bind the dropdown values manually and save the selected item to a SharePoint list.

For this, I have a SharePoint list [Employee Details], with columns below:

Column NameDepartment
Employee NameTitle
Employee DepartmentSingle line of text
Add Power Apps dropdown items to SharePoint list

On my Power Apps screen, an Edit form is connected to an above SharePoint list with the two text-input controls. However, I must replace the text input [Department] control with a dropdown control.

When the user selects a value from the dropdown control [Department].

Save dropdown field value to SharePoint list

The selected value will be saved to a SharePoint list as shown below:

Submit Power Apps drop down list to sharepoint list

Now, create a blank canvas app by using the SharePoint list and follow the below steps:

  • On the Power Apps screen, insert an Edit form -> add a new data source for the above SharePoint list and then Set the Edit form’s Data source property.

Where,

  • Employee Details = SharePoint list name
Power Apps save dropdown items to SharePoint list
  • By default, the text input control will be added to a department. Remove the Text-input control [Department] -> Select the Department DataCard and insert a Dropdown control as shown below:
Save Power Apps dropdown items to SharePoint list
  • Set the dropdown control, Items property to:
["IT","HR","Finance","Marketing"]
How to submit Power Apps dropdown items to SharePoint list
  • Now, we want to save the selected value from a dropdown to SharePoint list single line of text column. Insert a Button control -> Set its OnSelect property to:
Patch(
    'Employee Details',
    Defaults('Employee Details'),
    {
        Title: DataCardValue1.Text,
        Department: drp_Department.Selected.Value
    }
)

Where,

  • Employee Details = SharePoint list name
  • Title = SharePoint list title column
  • DataCardValue1 = Power Apps text-input control name
  • Department = SharePoint list column name
  • drp_Department = Power Apps dropdown control name
Power Apps dropdown\Power Apps submit dropdown items to SharePoint list
  • Once your app is ready, just SavePublish, and Preview the app when the user selects a value from the dropdown control and clicks on a button control.
Power Apps save dropdown value to the SharePoint list
  • The selected item of a dropdown control will be saved in a SharePoint list single line of text column as shown below:
How to save Power Apps dropdown values to SharePoint list

This is how to save the Power Apps dropdown value to a SharePoint list.

Validate Power Apps Dropdown Control

Let’s see the different scenarios where we can validate the Power Apps dropdown control.

  1. Validate the Power Apps dropdown using a button control
  2. How to validate the Power Apps dropdown using a text label control
  3. Working with the Power Apps dropdown validation using a text input

Validate the Power Apps dropdown using a button control

Now, let us validate the Power Apps dropdown control using a button.

Example,

I have a SharePoint Online list named “Project Tracker.” This list contains the below fields.

Column NameData Type
Project NameIt is a default single line of text, and I renamed it “Project Name.”
DescriptionMultiple lines of text
Project StatusChoice
Power Apps Dropdown Validation

On my Power Apps screen, I have added an Edit form connected to the above SharePoint list. The form contains a Dropdown control connected to the SharePoint list choice column. The dropdown has 3 choice values:

  1. Completed
  2. In Progress
  3. Not Started

Now, I validate the Power Apps dropdown control. The Button control will be visible when a user selects the dropdown value as Completed. Otherwise, the button won’t be visible, as shown below:

Power Apps Dropdown Control Validation

To achieve it, follow the below-mentioned steps:

  • Sign in to your Power Apps with your valid Microsoft 365 credentials.
  • Create Power Apps Canvas app -> Connect to the SharePoint Online list [Project Tracker]. Once the SharePoint list is added, it will appear under the Data section below.
How to Validate Power Apps Dropdown
  • Insert an Edit form -> Set its DataSource property to:
'Project Tracker'

Where,

  1. ‘Project Tracker’ = SharePoint Online List
Dropdown Validation in Power Apps Canvas app
  • Insert a Button control -> Set its DisplayMode property code like below:
DisplayMode = If(
    drp_ProjectStatus.Selected.Value = "Completed",
    DisplayMode.Edit,
    DisplayMode.Disabled
)

Where,

  1. If() = This Power Apps If() function is evaluate multiple unrelated conditions
  2. drp_ProjectStatus = Power Apps Dropdown Name
  3. “Completed” = SharePoint Choice Field Value
Dropdown Validation in Power Apps
  • Save, Publish, and Preview the app. If a user selects the project status as “Completed,” only the button control will be visible; it won’t be visible, as shown below:
How to Validate a Power Apps Dropdown Control

You can validate the Power Apps dropdown control using the button control. Now, let us see: whenever the user doesn’t select any value from the dropdown, I need to display the text label to select a value.

How to validate the Power Apps dropdown using a text label control

Now, let’s check how to validate the Power Apps dropdown using a text label control

For example, On my Power Apps screen, I added a Dropdown control and Text label control.

Now, I validate the Power Apps dropdown control; whenever the user doesn’t select a value, it will show me the warning message “Please Select the Manufacturer,” as shown below:

Dropdown Control Validation in Power Apps

To achieve it, follow the below steps:

  • On the Power Apps Screen -> Insert Dropdown control -> Set its Items property as:
[
    Blank(),
    "Sony",
    "Samsung",
    "Apple",
    "Tata Motors",
    "Intel"
]

Where,

  1. [Blank(), “Sony,”Samsung,” “Apple,” “Tata Motors,” “Intel”] = Power Apps Dropdown values
Dropdown Control Validation in Power Apps Canvas app
  • Insert a Text label control-> Set its Text and Visible properties as shown below.
Text = "Please Select the Manufacturer"

Visible = IsBlank(drp_Manufacturer.Selected.Value)

Where,

  1. “Please Select the Manufacturer” = Power Apps text label value
  2. IsBlank() = This Power Apps IsBlank() function tests for a blank value or an empty string
  3. drp_Manufacturer = Power Apps dropdown value
Dropdown Control Validation in a Power Apps Canvas app
  • Save, Publish, and preview the app. Whenever the user selects any value from the dropdown, the label text disappears or appears under the dropdown control, as in the screenshot below.
Dropdown Control Validation in the Power Apps Canvas app

This is how to validate a Power Apps dropdown control using a text label.

Power Apps Dropdown Validation Using Text Input

Let me show you how to validate the Power Apps dropdown control using text-input control.

Example:

I have a SharePoint Online list named “Monthly Budget Expenses.” This list contains the below fields.

Column NameData Type
ItemIt is a default single line of text; I just renamed it as “Item.”
CategoryChoice
BudgetChoice
AmountNumber
Power Apps Dropdown Validation Based On Other Dropdown

On my Power Apps screen, I have added a Dropdown control and Text input control. The dropdown control [Select Item] has different values.

Whenever the user selects a specific value from the dropdown, he/she will get the selected item value [Price] on the text input as shown below:

Dropdown Control Validation in Power Apps

To achieve this example, follow the below steps.

  • On the Power Apps Screen -> Insert a Dropdown control -> Set its Items property to:
'Monthly Budget Expenses'

Where,

  1. ‘Monthly Budget Expenses’ = SharePoint Online List
  2. Title = SharePoint Text Field Value
Dropdown Control Validation from Power Apps Canvas app
  • Insert a Text input control -> Set its Default property as:
drp_Item.Selected.Amount

Where,

  1. drp_Item = Power Apps Dropdown name
  2. Amount = SharePoint Number Field Column
Validate PowerApps Dropdown Control
  • Save, Publish, and Preview the app. The text input displays the price value based on the selected item from the dropdown control, as in the screenshot below.
How to Validate Power Apps Dropdown Control

This method displays text in the text input based on the user’s selected value from the dropdown.

Power Apps Convert Textbox to Dropdown

This section will take a simple scenario to convert the Power Apps text box with the Drop-down control. For that, follow the steps below:

  • Create a Power Apps Canvas app from Excel.
  • Convert Text input to a Dropdown list in Power Apps.
  • Save the dropdown value to the Excel sheet.

For example, I have an Excel Sheet [IT Companies] with two columns, as shown below:

Column NameData type
Company NameText
LocationChoice

Step 1: Create a Power Apps Canvas app from Excel

  • Open your Power Apps with respective Microsoft credentials.
  • Create a Power Apps Blank canvas app -> Connect to the Excel sheet [OneDrive for Business] as shown below:
How to convert text box to dropdown in Power Apps
  • On the Power Apps Screen, insert an Edit form -> Set its DataSource property to:
Companiees

Where,

  1. Companiees = Excel sheet table name
  • On the Power Apps Edit form, the Excel sheet choice column value has been represented in a text label format as shown below:
How to convert Power Apps text box to dropdown

Now, let’s check how to convert the text label with a dropdown control.

Step 2: Convert Text input to a Dropdown list in Power Apps

  • Now, select the Power Apps EditForm1 -> Select Edit fields option -> Choose Location DataCard and change the Control type to Allowed values as in the screenshot below:
powerapps convert textbox to dropdown
  • Then select the Location Dropdown -> Set its Items property to:
["Redmond","California","New York", "Astin"]

Where,

  1. Redmond, California, etc.. = Excel sheet choice column values
Convert Power Apps text box to dropdown

I converted the text label control with a dropdown; let’s check how to save the user-selected item to an Excel sheet.

Step 3: Save the dropdown value to the Excel sheet

  • On the Power Apps screen, Insert a Button Control -> Set its OnSelect property to:
SubmitForm(Form1);NewForm(Form1);

Where,

  1. Form1 = The Power Apps edit form control name
How to convert the text box to dropdown Power Apps
  • Once your Power Apps app is ready, Save, Publish, and Preview the app whenever the users select the value from the Power Apps dropdown control. Then click on the Save icon.
  • That record will be saved to the Excel sheet as shown below:
Convert text box to dropdown Power Apps

This is all about converting the Power Apps text label with the dropdown control.

Set Dropdown Default Value To Variable in Power Apps

In this section, I will explain Power Apps assign a dropdown default value to a variable.

Example,

I have a SharePoint list [User Subscription Details] that has various columns like:

Column NameData Type
User IDTitle
Country Single line of text
Subscription TypeChoice [Premium, Standard, Basic]
How to set Power Apps dropdown default value to variable

I created a Power Apps Canvas app and then added a Dropdown control connected to the above SharePoint list country column.

When the user opens the app, the dropdown item will be selected by default as “United States.” Then, the label [variable] will update automatically based on the dropdown selected value.

Set Power Apps dropdown default value to variable

Follow the below steps to achieve this:

  • On the Power Apps screen, insert a Dropdown control -> Set its Items property to:
Distinct('User Subscription Details',Country)

Where,

  1. User Subscription Details = SharePoint list name
  2. Country = SharePoint list column name
How to set dropdown default value to variable in Power Apps
  • Now, to set a variable based on the default value, select the Dropdown control -> Set its OnChange property to:
Default = "United States"


OnChange = Set(
    varCountry,
    drp_Country.Selected.Value
)

Where,

  1. United Stated = Dropdown value
  2. varCountry = Provide the variable name
  3. drp_Country = Dropdown control name
Set dropdown default value to variable in Power Apps
  • Insert the Text label control -> Set its Text property to:
varCountry

Where,

  • varCountry = Variable name
Power Apps dropdown set default value to variable
  • Save, Publish, and Preview the app. By default, the dropdown value will be selected as “United States.” Then, the text label [variable] will update automatically based on the dropdown selected value.
Power Apps set dropdown default value to a variable

This is how we can set a dropdown default value to a variable in Power Apps.

How to Bind SharePoint Lookup Column in Power Apps Dropdown

We will discuss adding a SharePoint lookup column in the Power Apps dropdown control here.

Example:

1. I have a SharePoint List, [Patient Tracker]. This list contains the fields below.

Column NameData Type
Patient IDThis is a default single line of text; I just renamed it as “Patient ID”
NameA single line of text
DOBDate and time
DiseaseLookup
Power Apps Dropdown Lookup

2. This SharePoint lookup column [Disease] is added from another SharePoint source list named “Diseases List.” This list contains the fields below.

Column NameData Type
DiseaseIt is a default single line of text, I just renamed it as “Disease”
Doctor’s NameA single line of text
Doctor’s ExperienceNumber
Doctor’s FeesCurrency
Power Apps Dropdown Lookup Column

3. In Power Apps, a “New Form” is connected to the SharePoint Online list. This form contains a Dropdown field called Disease [Lookup Column], having values like Diarrhea, Influenza, Lyme disease, etc.

4. When a user selects any value from the dropdown control, the text inputs will display the disease-related doctor’s name and fees based on the selected disease.

Refer to the below screenshot:

Power Apps Dropdown Lookup Field

To achieve the above example, follow the below-mentioned steps. Such as:

5. Create Power Apps Canvas app -> Connect to the SharePoint Online list [Patient Tracker]. Once the SharePoint list is added, it will appear under the Data section below.

Power Apps Dropdown Control Lookup Field

6. Insert an Edit form [frm_NewPatient] -> set its DataSource as:

DataSurce = 'Patient Tracker'

Where,

  • ‘Patient Tracker’ = SharePoint Online List

7. To display the SharePoint list fields in the form control, click the Edit fields option and add fields as needed.

8. To get the Edit Form to a New form, just set the Default mode as “New” as in the screenshot below.

How to display Power Apps dropdown lookup

9. Insert a Text input [Textinput_Doctor’sName] control inside the form and set its Default property to the code below.

Default = LookUp(
    'Patient Tracker',
    Disease.Value = drp_Disesase.Selected.Value,
    'Disease: Doctor''s Name'.Value
)

Where,

  • LookUp() = This Power Apps LookUp() function is used to find a single record that matches one or more criteria
  • ‘Patient Tracker’ = SharePoint Online List
  • Disease.Value = SharePoint lookup field value
  • drp_Disesase = Dropdown Control Name
  • ‘Disease: Doctor”s Name’ = It is a SharePoint additional column from the source list
How to display Power Apps dropdown lookup column

10. Then, insert another Text input control [Textinput_Doctor’sFees] -> Set its Default property as:

Default = LookUp(
    'Diseases List',
    Disease = drp_Disesase.Selected.Value,
    'Doctor''s Fees'
)

Where,

  • ‘Diseases List’ = SharePoint Source List
  • Disease = SharePoint Lookup column
  • ‘Doctor”s Fees’ = SharePoint Currency Field
How to display Power Apps dropdown lookup Field

11. Save, Publish, and Preview the app. If a user selects any value from the dropdown control, then text inputs will display the values based on the dropdown selected value, as shown below.

How to Bind SharePoint Lookup Column in Power Apps Dropdown

Conclusion

Dropdown control is a very widely used control in Power Apps. In this tutorial, I have explained in detail how to use a Power Apps dropdown control. Especially, I covered the following:

  • What is dropdown control in Power Apps and its properties?
  • Add items to a Power Apps dropdown control manually
  • How to add items to a dropdown control from a SharePoint list in Power Apps
  • Save Power Apps dropdown selected value to a SharePoint list
  • Validate Power Apps Dropdown Control
  • Power Apps Convert Textbox to Dropdown

You may also like: