Power Apps Dropdown Control – How to use

In this Power Apps tutorial, We will discuss Dropdown control in PowerApps, What are the properties, and how to add a Dropdown control in PowerApps.

Also, By taking some simple scenarios, We will cover these below topics:

  • How to add items in PowerApps dropdown control
  • How to add empty value in PowerApps dropdown
  • PowerApps dropdown values
  • How to get selected value in PowerApps dropdown
  • Set PowerApps dropdown default value
  • PowerApps dropdown blank default
  • Set PowerApps dropdown default selected value
  • PowerApps dropdown items manual
  • PowerApps dropdown multiple select
  • PowerApps dropdown multiple columns
  • PowerApps dropdown based on another dropdown
  • What is PowerApps dropdown binding
  • Display PowerApps dropdown items from sharepoint list
  • How to show PowerApps dropdown choices from sharepoint list
  • How to use PowerApps dropdown person field
  • PowerApps dropdown selected value to text
  • PowerApps dropdown set selected value
  • PowerApps dropdown concatenate values
  • PowerApps dropdown filter
  • PowerApps dropdown collection
  • PowerApps dropdown clear selection
  • PowerApps dropdown column names
  • PowerApps dropdown distinct values
  • PowerApps dropdown remove duplicates
  • PowerApps dropdown email
  • PowerApps dropdown groupby
  • How to work with PowerApps dropdown hours
  • PowerApps dropdown hide chevron
  • PowerApps dropdown hint text
  • PowerApps html dropdown
  • PowerApps hover dropdown
  • PowerApps hide dropdown value
  • PowerApps dropdown if statement
  • PowerApps dropdown lookup
  • PowerApps dropdown limit
  • PowerApps dropdown list of users
  • PowerApps dropdown not working
  • PowerApps dropdown onchange set variable
  • PowerApps dropdown overflow
  • PowerApps dropdown remove blank value
  • PowerApps dropdown search
  • PowerApps dropdown sort distinct
  • PowerApps dropdown transparent
  • PowerApps dropdown to radio
  • PowerApps dropdown validation
  • PowerApps dropdown with all
  • PowerApps dropdown yes no
  • PowerApps dropdown year
Table of Contents show

PowerApps dropdown control

  • Power Apps Dropdown control is a list or set of items that displays only the first item unless and until the user opens it. A user can select any value from the dropdown as per their choice.
  • When the list contains a large number of choice values, then the PowerApps Dropdown control will appear a maximum of 500 items (choice values) at a time.

PowerApps dropdown properties

Below represents some of the important key properties of PowerApps Dropdown control:

  1. Items = The source of data that contains the items that appear in the control. If the source has multiple columns, set the control’s Value property to the column of data that you want to show.
  2. Default = It specifies the initial value of a control before the user specifies a different value.
  3. Selected = It represents the selected item from the data record.
  4. Value = It defines the column of data that you want to display in the control.
  5. AllowEmptySelection = It defines whether the control shows an empty selection if no item has been selected. App users can also clear their choices by selecting the blank item.
  6. ChevronFill = It specifies the color of the down arrow in a dropdown list.
  7. ChevronBackground = It specifies the color behind the down arrow in a dropdown list.
  8. Color = It specifies the color of text in a control.
  9. DisplayMode = It defines whether the control allows user input (Edit), only displays data (View), or is disabled (Disabled).
  10. DisabledBorderColor = The color of a control’s border if the control’s DisplayMode property is set to Disabled.
  11. Fill = It specifies the background color of a control.
  12. Font = It provides the name of the family of fonts in which text appears.
  13. OnChange = When the user changes the value of a control, It specifies the actions to perform(for example, by adjusting a slider).
  14. OnSelect = When the user taps or clicks a control, it specifies an action to perform.
  15. PressedColor = It represents the color of text in a control when the user taps or clicks that control.
  16. PressedFill = It represents the background color of a control when the user taps or clicks that control.
  17. Reset = It defines whether a control reverts to its default value.
  18. SelectedText (Deprecated) = It represents a string value that represents the selected item.
  19. SelectionColor = It defines he text color of a selected item or items in a list or the color of the selection tool in a pen control.
  20. Size = It represents the font size of the text that appears on a control.
  21. Strikethrough = It defines whether a line appears through the text that appears on a control.
  22. Underline = It specifies whether a line appears under the text that appears on a control.
  23. Visible = It defines whether a control appears or is hidden.

Read PowerApps Dropdown Gallery

PowerApps dropdown add items

Next comes how we can add a Dropdown control and add items in that control in PowerApps. Follow these below instructions to add it.

  • On the PowerApps screen, Go to the Insert tab -> Select Input -> Click on Dropdown as shown below.
PowerApps Dropdown control
powerapps dropdown
  • To add the items in the PowerApps Dropdown control, Select the control and apply this below formula on its Items property as:
Items = ["AFRICA", "FRANCE", "AMERICA", "NEWZEALAND", "AUSTRALIA"]

Refer to the below screenshot.

PowerApps dropdown add items
powerapps dropdown example

PowerApps dropdown add empty value

Here, We will see how we can add an empty value in the PowerApps Dropdown control.

  • The below screenshot represents a PowerApps Dropdown control. The dropdown values are retrieved from a Sharepoint List (Product Info).
  • Whenever we are adding the values into the Dropdown control, by default always it shows the first choice value. However, I want to show a blank or empty value to the dropdown control when a user opens the app.
  • For example, normally you can see the dropdown control shows the value as Bread. Instead of the Bread value, I want to set a blank value (that should be default value), so that when I will open the app, it will show me a blank choice in the dropdown control as shown below.
Power Apps dropdown add empty value
PowerApps dropdown add empty value
  • Below is the SharePoint List (Product Info). This list contains three columns named ID, Title and Product Location. I have displayed the Title column in the PowerApps Dropdown control.
PowerApps dropdown add empty value
  • To set a blank value to the dropdown control, you need to create a PowerApps Collection on Screen’s OnVisible property and then bind this created collection to the Dropdown control.
  • Apply this below code on screen’s OnVisible property as:
OnVisible = ClearCollect(
    ProductsWithBlank,
    {Product: Char(160)}
);
Collect(
    ProductsWithBlank,
    'Product Info'.Title
)

Where,

  1. ProductsWithBlank = Collection name
  2. Product = Header of the collection
  3. ‘Product Info’ = SharePoint list name
  4. Title = Specify the column that you want to display in the dropdown control
  • To avoid the dropdown bug where blank entries appear with a smaller height (can be hard to select on small screens, such as phones). So to avoid this, you can work around this by defining the name as a ‘non-breaking space’.
PowerApps drop down add empty value
How to add empty value in PowerApps dropdown
  • Next, Select the dropdown control and set its Items property to the collection as:
Items = ProductsWithBlank
How to add an empty value in PowerApps dropdown control
How to add empty value in PowerApps dropdown control
  • Now save and publish the app. Once you will reopen the app again, then you can see a blank value appear in the dropdown control.

PowerApps dropdown values

  • PowerApps Dropdown Add Items and Dropdown Values both are the same. The meaning of this, we need to create an option set in the PowerApps Dropdown control.
  • You can do the same process as the dropdown add items, Select the Dropdown control and insert the dropdown choice values on its Items property as:
Items = ["OptionA", "OptionB", "OptionC", "OptionD", "OptionE"]

Where,

OptionA, OptionB, OptionC and so on = Dropdown choices

  • While adding the values into the dropdown control, you must ensure to put the values within the [ ] bracket including the inverted comma (“”). Otherwise, the code will show error.
PowerApps dropdown values
PowerApps dropdown values

PowerApps dropdown selected value

  • When you are working with the PowerApps Dropdown control, Sometimes what happens is, the formula of the dropdown value may occur with an error.
  • That means, suppose you have given the Items property of any other control (Data table, Gallery) to “Dropdown.Selected.Value” and it doesnot work.
  • So in this case, what you can do is, you can try some other formulas like below:
Dropdown.Selected.ColumnName

Where,

ColumnName represents the SharePoint column name

Or you can try,

Dropdown.Selected.Result

Or you can try,

Dropdown.SelectedText

PowerApps dropdown default value

Do you want to set the Default Value to the Power Apps Dropdown control? Follow these below examples to workaround with this.

Example – 1:

There is a SharePoint List named Project Details. This list has these below columns with different data types as:

  1. Title = By default this is a single line of text data type column
  2. Employee First Name = Single line of text data type
  3. Employee Last Name = Single line of text data type
  4. Employee Job = Choice column
  5. Client = Single line of text data type
  6. Project Created Date = Date Time column
  7. Project Status = Choice column
set Power Apps dropdown default value
  • In this example what I would like to set the default value for the Date field and as well as the Dropdown field in the edit form of the app.
  • Whenever we are connecting the Sharepoint list data source to the form, then the form is creating with all the SharePoint fields automatically.
  • For a SharePoint DateTime column, it is creating a Date picker control within the form. Similarly, for all the SharePoint Choice columns, it is creating a combo box for each column.

Set Default value of a Date picker control

  • In the Edit form, Select the Date picker control (Project Created Date) and apply this below formula on its DefaultDate property as:
DefaultDate = If(
    Form1.Mode = FormMode.New,
    Now(),
    Parent.Default
)

Where,

Form1 = PowerApps Edit Form name

PowerApps dropdown default value
PowerApps dropdown default value

Set Default value of a Combo box control

  • In the Edit form, Select the Combo box control (Project Status) and set this below code on its DefaultSelectedItems property as:
DefaultSelectedItems = If(
    Form1.Mode = FormMode.New,
    {Value: "Pending"},
    Parent.Default
)

Where,

  1. Form1 = Edit form name
  2. Pending” = Specify the choice value that you want to make as default status value
Power Apps dropdown default value
PowerApps dropdown default value example
  • Save and Publish the app. Once you will reopen the app again, then you can see the default date (today) and default status has set as shown below.
set PowerApps dropdown default value
How to set default value in PowerApps drop down

Example – 2:

  • There is a SharePoint List named Credit Projects. This list has some various columns along with the choice column called Company Type.
  • This choice column contains two choice options as Private and Public. Also, this list has some records as shown in the below screenshot.
  • Here what I want to do is, whenever a user will open the app, then this choice dropdown control will appear with the selected default value (Public).
PowerApps dropdown control default value
  • The below screenshot represents the PowerApps Edit form. Before you can see there is no default value in the Company type field. Now I would like to set a Default value and that should be Public whenever a user opens the app.
how to set dropdown default value in Powerapps
set dropdown default value in Powerapps
  • To do so, Select the Choice field Data card (Company Type) and apply this below formula on its Default property as:
Default = LookUp(
    Choices('Credit Projects'.'Company Type'),
    Value = "Public"
)
  • You need to specify the choice value that you want to set as Default and that should match with the SharePoint Choice value.
  • Also, one most important thing is, before applying the formula, you must ensure to unlock the choice field data card.
how to set dropdown default value in Power Apps
Set default value in drop down in PowerApps
  • Now Save and Preview the app. You can see the default value in the choice dropdown data card as shown in the above screenshot.

PowerApps dropdown blank default

In some cases what happens is, you need to set a blank default value to the PowerApps Dropdown control. To learn about this, there is a detailed guide available on my site that you can go through by using the below link:

PowerApps dropdown default selected value

  • When you are inserting a Dropdown control to the app, there will be some sample items as like [“1”, “2”, “3”].
  • Once you will select the Default property of that control, you can see always it contains the first item as the Default value i.e. “1”.
  • Suppose you want to set the Default value as per your own, then you can provide the choice option from the dropdown control.
  • The below screenshot represents an Edit form and the fields are retrieved from a SharePoint List called Project Details.
  • In the form, there is a field called Client Project and I want to set its Default value as the first option from that field.
  • To do so, Select the Dropdown control and apply this below formula on its Default property as:
Default = ThisItem.'Client Project'

Where,

Client Project = SharePoint List Column name

PowerApps dropdown default selected value
PowerApps dropdown default selected value
  • Save, Publish and Close the app. When you wil reopen the app and form again, you can see the dropdown default value will appear with the first value from the SharePoint field (Client Project).

PowerApps dropdown items manual

First of all, you should know what does the mean of dropdown items manual is in PowerApps and how you can use it.

  • PowerApps dropdown items manual means the way you are adding the option sets or items to the dropdown control manually as like [“Choice1”, “Choice2”, “Choice3”, etc.]
  • The another thing is by applying some condition, how you can perform actions and add items in the PowerApps Dropdown control. For example, suppose you want to show or hide some fields based upon the dropdown selection.
  • For more details, you can refer to this below PowerApps tutorial that how you can workaround this.

Show hide fields based on dropdown selection PowerApps (2 Examples)

PowerApps dropdown multiple select

  • Suppose in some cases, at a time you need to select more than one item in the Power Apps Dropdown control, then what you will do? At the same time, you may think that, Is there any way to select multiple items in the dropdown control?
  • Coming to the answer to this question is, No, you can not select more than one item in the Power Apps Dropdown control. At a time you can able to select only one item in the control.
  • Alternatively, for multi-selection, you can either use a Combo Box control or a List Box control in Power Apps. By using these two controls, you can select one or multiple items at a time.

PowerApps dropdown multiple columns

Do you want to display more than one column into your PowerApps Dropdown control? Yes, you can use multiple columns to the dropdown control. Follow these below examples that how you can use it.

Example – 1:

In this example, We will see how to use multiple columns from the same data source and as well as from different data sources. Here, I have used the SharePoint List Data sources.

Power Apps dropdown multiple columns from same SharePoint List

In Dropdown, to display multiple columns from the same SharePoint List, Select the Dropdown control and apply this below code on its Items property as:

Items = Concatenate(
    'Project Details'.Title,
    " - ",
    'Project Details'.'Employee First Name'
)

Where,

  1. ‘Project Details’ = SharePoint List name. You can refer to this list from the above example (PowerApps dropdown default value)
  1. ” – “ = It is the delimiter that helps to specify a hyphen (-) between two columns. You can specify any delimiter that you want to show
  2. Title, ‘Employee First Name’ = These are the SharePoint columns with Single line of text data type
PowerApps dropdown multiple columns
PowerApps dropdown multiple columns example

Save and Preview the app. Once you will select the dropdown control, you can see the multiple columns with a delimiter (-) as shown below.

Power Apps dropdown multiple columns
PowerApps dropdown multiple columns example

Power Apps dropdown multiple columns from different SharePoint List

Next comes how you can use multiple columns from different SharePoint Lists. There are two different SharePoint Lists named Product Info and Shopping Cart.

I want to concatenate the Title columns from both lists and display them in a Dropdown control. To do so, select the Dropdown control and apply this below code on its Items property as:

Items = Concatenate(
    'Product Info'.Title,
    " - ",
    'Shopping Cart'.Title
)

Refer to the below screenshot.

Power Apps dropdown multiple column

Save and Preview the app. Once you will select the dropdown control, you can see the multiple columns (from different SharePoint List) with a delimiter (-) as shown below.

PowerApps dropdown control multiple columns

Example – 2:

  • There is another way to display multiple columns in a PowerApps Dropdown control. Here, we will use the Power Apps AddColumns Function and also the Concatenate method. Refer to the below instructions.
  • Below represents a SharePoint List named Credit Projects. This list has some columns like:
  1. Project Name = This is a Title column. I just renamed it to Project Name
  2. Current Status = This is a Choice column.
Power Apps dropdown control multiple columns
  • Now I want to display these two columns (Project Name and Current Status) in the dropdown menu. For this, I have applied this elow formula on Dropdown’s Items property as:
Items = AddColumns(
    'Credit Projects',
    "ProjectAndStatus",
    Concatenate(
        Title,
        " - ",
        'Current Status'.Value
    )
)

Where,

  1. “ProjectAndStatus” = Specify the new column name that you want to add to the data source.
  2. Title = Project Name column
  3. Current Status = As this column is a Choice data type, so we need to put a “.Value
  • After this, next what you need to do is, you have to set the new Column value to the Dropdown control. Select the Dropdown menu -> Go to Properties pane -> Select the new column name that you have created (ProjectAndStatus) as like below screenshot.
  • Unless and until you will not select the Dropdown value, the control will give as the blank result.
how to use multiple columns in PowerApps dropdown
  • Save and Preview the app. Once you will select the dropdown control, you can see the multiple columns with a delimiter (-) as shown below.
Use multiple columns in PowerApps dropdown

PowerApps dropdown based on another dropdown

Can we work with one Dropdown control based on other dropdown control in PowerApps? Yes, of course, you can display one dropdown control value depends upon other dropdown control values. Let’s do one example.

  • I have a SharePoint List named Shopping Cart having with these below fields:
  1. Cart ID = Number Data type column
  2. Title = By default this is a Single line of text data type
  3. Price = Currency Data type
  4. Color = Choice Data type
PowerApps dropdown based on another dropdown
  • In the app, there are two Dropdown controls where the first dropdown is having all the item cart IDs.
  • Here what I want to do is, the user will select a specific ID from the first Dropdown control and the second dropdown will appear with all the values depends upon the selected ID.
Power Apps dropdown based on another dropdown
PowerApps dropdown based on another dropdown
  • The first Dropdown menu is having with all the Cart IDs that are retrieved from the SharePoint list (Shopping Cart). Below is the code that applied in Dropdown’s Items property as:
Items = 'Shopping Cart'.'Cart ID'
PowerApps dropdown based on another dropdown control
  • Next, Select the second Dropdown control and set its Items property as:
Items = Filter(
    'Shopping Cart',
    'Cart ID' = Dropdown8.Selected.'Cart ID'
)

Where,

Dropdown8 = First Dropdown control name having with all Cart IDs

PowerApps dropdown based on other dropdown
  • At last, Save and Preview the app. Once you wil select any ID from the first Dropdown control, then all the item ID related value will appear in the second dropdown control.
Power Apps dropdown based on other dropdown

PowerApps dropdown binding

Suppose in your app, you want to bind some Dropdown value to any other control. To work around this, you can do the following things.

  • There is a SharePoint List called Travel Details. This list has some columns with different data types. Also, it has some records as shown below.
PowerApps dropdown binding
  • In the app, there is a Dropdown control and it has all the Title values (Traveler) that are retrieved from the list.
  • Now I would like to bind this dropdown value in a Label control and that label will display the ID of that selected dropdown item.
  • To do this, Select the Label control and apply this elow code on its Text property as:
Text = First(
    Filter(
        'Travel Details',
        Title = Dropdown10.Selected.Title
    )
).ID

Where,

Dropdown10 = Dropdown control name

Power Apps dropdown binding
  • Save and Preview the app. Select any item from the Dropdown control and then the label control will appear with the selected item ID as shown above.

PowerApps dropdown items from sharepoint list

  • As in the above we discussed how we can get items to dropdown menu from the SharePoint list. Simply, We can put a simple code to the Dropdown control’s Items property and get the proper result.
  • The Dropdown formula or code should be as like below:
Items = 'Shopping Cart'.Title

Where,

  1. Shopping Cart = SharePoint List name
  2. Title = Specify the SharePoint Column name that you want to display in the Dropdown menu
PowerApps dropdown items from sharepoint list
  • Once you will save and preview the app, you can see all the title values in the dropdown menu as shown above.

PowerApps dropdown choices from sharepoint list

Similarly, Suppose you want to display a SharePoint Choice field in the PowerApps Dropdown control, then you need to apply this below code that has been explained in the scenario.

  • There is a SharePoint List named Patient Registration Details having with a Choice field called Location. This choice field has some choice options like Bangalore, Hyderabad, Mumbai etc.
  • Now I would like to show these choice field values in the dropdown menu.
Power Apps dropdown choices from sharepoint list
  • Select the Dropdown control and apply this below code on its Items property as:
Items = Choices('Patient Registration Details'.Location)

Or you can try,

Items = Choices('Patient Registration Details'.Location).Value

You can apply both the formula to get the SharePoint choice values.

PowerApps dropdown choices from sharepoint list
PowerApps dropdown choices from sharepoint list
  • Once you will save and preview the app, you can see all the choices in the Power Apps Dropdown control.

Check out this below PowerApps tutorial to work with the Choice function:

Power Apps Choices Function with Examples

PowerApps dropdown person field

Do you want to display the SharePoint Person field in the PowerApps Dropdown control? Refer to the below code to do so.

  • There is a SharePoint List named Travel Details. In this list, there is a People Picker field called “Assigned To“.
  • Now I want to display this person field values in the PowerApps Dropdown menu. That means, it will show all the user names to whom the task is assigned to.
  • Select the Dropdown control and apply this below formula on its Items property as:
Items = Distinct('Travel Details','Assigned To'.DisplayName)
PowerApps dropdown person field
PowerApps dropdown person field
  • When you will save and preview the app, you can see all the person names in the dropdown control.
  • Suppose, you want to display the dropdown selected item in a Label control. Then put this below code on Label’s Text property as:
Text = Dropdown5.Selected.Result

Where,

Dropdown5 = Person Dropdown control name

Power Apps dropdown person field

This is how you can work with the PowerApps dropdown person field. Also, you can refer to the below PowerApps tutorial to know more details about PowerApps People picker:

Create People Picker in PowerApps with Combo Box

PowerApps dropdown selected value to text

In this topic, We will see how to work with Power Apps dropdown selected value to the text. Refer to the below simple example.

  • On the PowerApps Screen, there is a Dropdown control and a Button input. When I click on a button I would like for it to go to a screen if the selected text in a dropdown menu matches with a certain word.
  • In my Dropdown control, I have some option set like FOOTBALL, CRICKET, HOCKEY etc. When I will select the option as CRICKET, and tap on the button, then it will navigate to the next screen.
  • To do so, Select the Button control (Click Me) and set its OnSelect property as:
OnSelect = If(
    Dropdown13.SelectedText.Value = "CRICKET",
    Navigate(
        Screen4,
        ScreenTransition.Fade
    )
)

Where,

  1. Dropdown13 = Dropdown control name where all choices are present
  2. CRICKET = Specify the choice value that should match with the Dropdown value and then it will navigate to the next screen
  3. Screen4 = Provide the screen name that you want to navigate
PowerApps dropdown selected value to text
  • Now Save and Preview the app. Select the item as CRICKET from the Dropdown control and then click on the button, then you can see the current screen will navigate to the user-provided new screen.

PowerApps dropdown set selected value

Suppose you need to set a dropdown value as the default value in PowerApps and that should be on a Button click. To do this, check the below-tested scenario.

  • There is a Dropdown control and a Button input. The dropdown control is having items with these below values:

[“Rome”, “Jack”, “James”, “Gold”]

  • Now I would like to set a default value in the dropdown control when a user will press on the button. Below represents a Button control named Hit Me.
Power Apps dropdown set selected value
  • At first, Select the dropdown control and set its OnChange property as:
OnChange = Set(varDDValue, Dropdown14.Selected.Value)

Where,

  1. varDDValue = Variable name
  2. Dropdown14 = Dropdown control name
Power Apps dropdown control set selected value
set selected value in PowerApps dropdown
  • Next, Select the Button control and apply this below formula on its OnSelect property as:
OnSelect = Set(varDDValue, "James")

Where,

“James” = Specify the dropdown choice-value that you want to set as the default selected value

Set PowerApps dropdown selected value
set selected value in Power Apps dropdown
  • At last, you need to set the specified variable name to the Dropdown’s Default property as:
Default = varDDValue
Set Power Apps dropdown selected value
How to set selected value in PowerApps dropdown
  • Save and Preview the app. Select any choice (except James) from the dropdown and hit the button. You can see the value will change to the default selected option (James).
PowerApps dropdown set selected value
How to set selected value in Power Apps dropdown

PowerApps dropdown concatenate values

In Power Apps, Do you want to concatenate values from multi-dropdown controls (or maybe other controls)? Check out this below scenario that how you can do it in a simple way.

  • You can see there are two different Dropdown controls named TRAVELER and DRIVER. All the dropdown values are retrieved from a SharePoint List data source.
  • Also, there is a Label control that helps to show the concatenate result of both the dropdown controls. Lets say you selected the Traveler as ‘Leornado’ and the Driver as ‘Krish’. Then the output will come as Leornado – Krish.
PowerApps dropdown concatenate values
  • To do this, you can use an ampersand to concatenate text of different input controls. Select the Label control and apply this below formula on its Text property as:
Text = Dropdown14.Selected.Title & " - " & Dropdown15.Selected.Driver

Or you can use this below code where I have used the Power Apps Concatenate function.

Text = Concatenate(Dropdown14.Selected.Title," - ",Dropdown15.Selected.Driver)

Where,

  1. Dropdown14 = Traveler Dropdown control name
  2. Dropdown15 = Driver Dropdown control name
  3. Title = Column name from SharePoint list
  4. Driver = It is also a SharePoint Column
Power Apps dropdown concatenate values
PowerApps dropdown concatenate values
  • Once you will save and preview the app, you can see the result.

PowerApps dropdown filter

In this topic, We will see how we can work with the Power Apps dropdown filter from SharePoint List.

  • The below screenshot represents a SharePoint List named Book Details. This list contains with these below columns as:
  1. Book Name = By default, this is a Title column. Just I renamed it to Book Info.
  2. Book Info = Yes No Data type column
  3. Book Price = Numer Data type column
  4. Book Author = Person Data type
  5. Book Availability = Date Time column
PowerApps dropdown filter
  • On the PowerApps screen, there is a Dropdown control and a Data table. The dropdown control is having all the Book name (Title) that are retrieved from the SharePoint List.
  • Here what I would like to do is, a user will select any book name from the dropdown menu and at the same time, the data table will display the user selected book details.
  • For example, I have choosen the Book as PowerApps and in the Data table, its showing all the related details aout this book like its Price, Its Author etc as shown below.
Power Apps dropdown filter
PowerApps dropdown filter
  • To achieve this, you need to set this below code on the Data table’s Items property as:
Items = Filter(
    'Book Details',
    Title = Dropdown16.Selected.Title
)

Or you can use the below formula as:

Items = Filter(
    'Book Details',
    Title = Dropdown16.SelectedText.Value
)

Where,

  1. Title = SharePoint Column name (Book name)
  2. Dropdown16 = Dropdown control name
Power Apps drop down filter
PowerApps dropdown filter example
  • Save and Preview the app. Select any book name from the dropdown menu, then you can see its all details as like the above screenshot.

PowerApps dropdown collection

Do you need to display the Power Apps Collection values in the Power Apps Dropdown control? Then, take a try with this below scenario.

  • At first, We will create a Collection on the apps screen’s OnVisible property as:
OnVisible = ClearCollect(
    colEventSummary,
    {
        Comments: "No comments",
        Event_Detail: "Ditching",
        Event_Type: "Production",
        Hours: "10",
        Id: 1,
        Minutes: "15"
    },
    {
        Comments: "No comments",
        Event_Detail: "Ditching1",
        Event_Type: "Development",
        Hours: "12",
        Id: 1,
        Minutes: "30"
    }
)

Where,

  1. colEventSummary = Collection name
  2. Comments, Event_Detail, Event_Type, Hours, Id, Minutes = Collection Headers
PowerApps dropdown collection
  • Now I would like to display the Event type and Event Detail values (from collection) in two different Dropdown controls.
  • To do so, Insert two Dropdown controls i.e. one for Event Type and other one for Event Detail.
  • Select Event Type Dropdown control and apply this below code on its Items property as:
Items = Distinct(
    colEventSummary,
    Event_Type
)
Power Apps dropdown collection
PowerApps dropdown collection example
  • Similarly, Select Event Detail Dropdown control and apply this below code on its Items property as:
Items = Distinct(
    colEventSummary,
    Event_Detail
)
Power Apps drop down collection
  • Now Save, Publish and Close the app. Reopen the app again. Once you will preview the app, you can see the Dropdown values will appear with these (Event type and Event Detail) values.
dropdown collection in Power Apps

Important Note:

If the Dropdown controls are present within the Edit Form, then you should try with these below formulas to get the collection header values.

  1. Set the Default property of the Event Type Dropdown control to the following formula:
Default = ThisItem.Event_Type

2. Set the Default property of the Event Detail Dropdown control to the following formula:

Default = ThisItem.Event_Detail

PowerApps dropdown clear selection

Do you want to reset the choice values in the Power Apps Dropdown control? There are many ways you can use or follow to reset the Dropdown control. Below represents some of the different ways that I have collected here to reset the control.

Example – 1:

  • There is the simplest way where you can reset the dropdown menu by using the Reset property. What you have to do is, Select the screen, go to its OnVisible property and then apply this below code:
OnVisible = Reset(ddGadgets)

Where,

ddGadgets = Specify the dropdown control name. Here, you need to make sure that the specified dropdown control name should be correct.

PowerApps dropdown clear selection
  • Now Save, Publish and Close the app. Once you will reopen the app again, you can see the difference that the dropdown menu has reset to its Default value.

Example – 2:

  • There is another way where we can reset the Dropdown control in the app. What we will do is, We will set a Context variable in the Dropdown’s Reset property and then we will apply the code where we want to trigger the reset (like Button’s OnSelect property, Screen’s OnVisible or OnHidden property etc.)
  • At first, Select the Dropdown control and set a variable on its Reset property as:
Reset = ResetVar

Where,

ResetVar = Variable name

Power Apps dropdown clear selection
  • In this example, I have taken a Button input where I want to trigger on its OnSelect property:
OnSelect = UpdateContext({ResetVar: true});
UpdateContext({ResetVar: false})
Power Apps reset dropdown
  • Save and Preview the app. Select any value from the Dropdown menu and then tap on the button to reset. Once you will click, then the dropdown menu will reset to its default value.

PowerApps dropdown column names

Suppose you want to view all the SharePoint List column names in a PowerApps Dropdown control. Then follow the below code that how you can achieve this.

  • There is a SharePoint List named Book Details. This list has some columns like:
  1. Title
  2. Book Info
  3. Book Price
  4. Book Author and so on
  • Also, When you are creating a new list, there are some by default columns like Author, ID, Created, Modified etc. So all these columns will also appear in the dropdown menu.
  • To do this, At first, We need to store the contents of list inside a collection and then put the colection name on the Items property of the dropdown control.
  • Select the OnVisible property of the Screen and apply this below code as:
OnVisible = ClearCollect(
    colBookInfo,
    'Book Details'
);
Set(
    varColumnNames,
    Distinct(
        Ungroup(
            MatchAll(
                JSON(
                    colBookInfo,
                    JSONFormat.IgnoreBinaryData
                ),
                "([^""]+?)""\s*:"
            ).SubMatches,
            "SubMatches"
        ),
        Value
    )
)

Where,

  1. colBookInfo = Collection name
  2. Book Details = SharePoint List name
  3. varColumnNames = Specify a variable name
PowerApps dropdown column names
  • Select the Dropdown control and set its Items property to the specified variable name as:
Items = varColumnNames
PowerApps drop down column names
  • Save, Publish and close the app. Reopen the app and preview the dropdown menu. You can see all the list columns will appear in the dropdown menu as shown below.
Power Apps dropdown column names

PowerApps dropdown distinct values

By taking some different types of scenarios, We will check out how to work with dropdown distinct values in Power Apps. Before that, we should know what is Distinct function in Power Apps and its syntax. Below represents a short description.

PowerApps Distinct Function:

Power Apps Distinct function helps to remove the duplicate values from any data source like Excel, SharePoint List, etc. When you will define this Distinct function, then always it shows the unique values from the data source.

Syntax:

Below represents the syntax of PowerApps Distinct Function:

Distinct(ListName, ColumnName)

The above code specifies it will remove all the duplicate values from the specific SharePoint column and collect the unique values. Refer to these below different scenarios to understand better.

Example – 1: (Distinct people picker Dropdown)

  • In this scenario also, I have taken the same SharePoint List Book Details. In this list there is a Person field (Single values only) named Book Author.
  • Now I would like to populate a dropdown menu with distinct people values from that list (Book Details). To workaround with this, select the dropdown control and apply this below code on its Items property as:
Items = Sort(
    Distinct(
        'Book Details',
        'Book Author'.DisplayName
    ),
    Result,
    Ascending
)

Where,

‘Book Author’.DisplayName = Book Author is the SharePoint list name and for the person field we need to specify the value as Display name with “.”

PowerApps dropdown distinct values
  • Once you will save and preview the app, you can see the distinct result in the dropdown control as like the above screenshot.

Example – 2: (Distinct Date Dropdown)

In this scenario, We will get the distinct Date from the SharePoint Date field and then we will filter the items based upon the selected date.

  • There is a SharePoint List called Products. This list has some different type of columns with different data types. Among them, there is a Date Time field named Sales Date. As you can see, this field has some records with duplicate dates.
PowerApps dropdown distinct value
  • Now I would like to get the unique dates and display it in a Dropdown control. Also, I want to filter the items based on the selected date and display those items in a Gallery control.
  • For example, In the dropdown menu, I have selected a Date as 18 and the gallery shows all the records that are sold out on the selected date.
Power Apps dropdown distinct value
  • For this, Select the Dropdown control and set the below code on its Items property as:
Items = Distinct(Products,'Sales Date')
distinct value in PowerApps dropdown
  • Once you will apply the above code, then the dropdown menu will appear with all the distinct dates from the SharePoint list.
  • Next, Insert a Gallery control and apply this below formula on its Items property as:
Items = Filter(
    Products,
    'Sales Date' = Dropdown23.Selected.Result
)

Where,

Dropdown23 = Date Dropdown control name

distinct value in PowerApps dropdown control

This is how we can get the distinct Date from the SharePoint Date column.

PowerApps dropdown remove duplicates

In this scenario, We will check how to remove duplicates from a Choice Dropdown and also the data should be retrieved from a collection.

  • There is a Project Details SharePoint List that contains a Choice field named Project Status. This choice field has some schoice values like Submitted, Approved, Rejected and Pending.
  • Here I want to display all these choice values in a PowerApps Dropdown control.
  • At first, Select the OnVisible property of the screen and create a collection by using the below code:
OnVisible = ClearCollect(
    colProjectStatus,
    Distinct(
        Choices('Project Details'.'Project Status'),
        Value
    ).Result
)

Where,

colProjectStatus = Collection name

Refer to the below screenshot.

PowerApps dropdown remove duplicates
  • Next set this created collection into the Dropdown’s Items property as:
Items = colProjectStatus
PowerApps dropdown remove duplicate
  • At last, Save, Publish and close the app. When you will reopen the app, you can see all the choice values will appear in the dropdown control as like the below screenshot.
Power Apps dropdown remove duplicates

PowerApps dropdown email

Can you ever think that we can do the DropDown selection in Email body for Power Apps? Yes, we can use the dropdown control value in the PowerApps Email Subject or Email Body. Follow the below instructions that how you can use it.

  • On the PowerApps, there is a Dropdown control and a Button input (SEND). The button will help you to send the email to particular users.
  • The Dropdown menu is having these below values on its Items property as:
Items = ["HR Team Meeting", "IT Team Meeting", "FINANCE Team Meeting"]
  • Now, I would like to add this dropdown values in the PowerApps Email Subject and that will send to the specific user email.
PowerApps dropdown email
  • Next, Select the Send button and apply this below formula on its OnSelect property as:
OnSelect = Office365Outlook.SendEmail(
    "Preeti@tsinfo.onmicrosoft.com",
    "Subject: " & Dropdown37.Selected.Value,
    "The Meeting has been scheduled today at 4PM. Kindly join in the call."
)

Where,

  1. Preeti@tsinfo.onmicrosoft.com” = Provide the email address of the user to whom you want to send the email.
  2. Dropdown37 = Specify the dropdown control name. Here I have specified the dropdown value in my Subject section. If you want, you can put it in the Body section also. If the Dropdown control is present in the form, then you should mention as “DataCardValueName.Selected.Value
  3. “The Meeting has been scheduled today at 4PM. Kindly join in the call.” = This is the Email Body section.
Power Apps dropdown email
  • Save and Preview the app. Select any value from the Dropdown control that you want to apply in the subject section and then tap on the button.
  • Now open the 365Outlook of specific user email that you have mentioned in the formula. There you can see the email has been appeared as shown below.
PowerApps send email dropdown
  • Also, you can try this below formula to use the Dropdown values in PowerApps Email as:
Office365Outlook.SendEmail(emailAddress.Text, "Email subject: " & Dropdownname.Selected.Value, emailText.Text)

Where,

emailAddress, emailText = Text input control name

PowerApps dropdown groupby

In this topic, We will see how to use the PowerApps GroupBy function in the Dropdown control.

Example – 1:

  • There is a SharePoint List named Customer Care Report Details. In this list, there are different types of SharePoint fields as you can see in the below screenshot. Among them, there is a Single line of text data type field called Customer Care Report For.
  • Here I would like to display the unique value of the above single line field (Customer Care Report For) rather than the repeated value. The result will display in a Dropdown control.
  • To achieve this need, We can use PowerApps Distinct function and as well as the GroupBy function.
PowerApps dropdown groupby
  • What you can do is, Select the Dropdown control and set this below code on its Items property as:
Items = GroupBy(
    'Customer Care Report Details',
    "CustomerCareReportFor",
    "GroupData"
)

Where,

“GroupData” = Group name

Power Apps dropdown groupby
  • Once you will save and preview the app, you can see the unique values will appear in the dropdown control.

Example – 2:

  • In the below scenario, there are two Dropdown controls i.e. one is for “Customer Care Reports For” and other one is for the “Customer Name“.
  • Here I would like to display the Customer care reports for in the first dropdown and in the second dropdown, who is its customer, it will display automatically based upon the first dropdown selection.
  • In the below screen, you can see, As I have selected the reports for BSNL, the second dropdown is displayed with all the customer names for that BSNL report.
PowerApps dropdown control groupby
  • To workaround with this, Set the below code on first dropdown’s Items property as:
Items = Distinct(
    'Customer Care Report Details',
    'Customer Care Report For')
Power Apps dropdown control groupby
  • Next, Select the second dropdown control (Customer Name) and apply this below formula on its Items property as:
Items = Distinct(
    Filter(
        'Customer Care Report Details',
        'Customer Care Report For' = Dropdown38.Selected.Result
    ),
    'Customer Name'
)

Where,

Dropdown38 = First Dropdown control name (Customer Care Reports For)

Groupby in PowerApps dropdown
  • Once it is done, just save, preview the app and perform the operation that you want.

PowerApps dropdown hours

To workaround with Dropdown Hours in PowerApps, you can check out this below PowerApps article that I have shared on my site:

How to use date time picker in PowerApps

PowerApps dropdown hide chevron

Normally whenever you are adding a Dropdown control or a Combo box control, you can see there is an arrow mark or symbol at the right side of the control. When users click on that symbol, then all the choice values appear in the control. This symbol or marker is known as Chevron. Refer to the below figure.

PowerApps dropdown hide chevron
  • Suppose you want to change the shape and size of the Chevron in the dropdown control. Then in this case, you can use some properties like ChevronFill, ChevronBackground etc.
  • Lets say, you want to hide the chevron from the dropdown control. In that case, you can use ChevronFill property.
  • Select the Dropdown control and apply this below color code on its ChevronFill property as:
ChevronFill = RGBA(0,0,0,0)
Power Apps dropdown hide chevron
  • Similarly, if you want to hide the background color of the Chevron, then you can use the same color code to Dropdown’s ChevronBackground property. Then the user can not see the chevron symbol.
PowerApps drop down hide chevron
  • But in the preview time, When you will hover on to the dropown control, then you can see the chevron symbol.

PowerApps dropdown hint text

  • A Hint text means it is the text placeholder that can contain any Power Apps Control. But unfortunately, there is no such property of the Dropdown control where we can set a hint text.
  • Power Apps Dropdown control can not display the input text place holder because this control does not have a search capability like a Combo Box control. To display the hint text, you can use a Combo box control instead of the Dropdown control.
  • In the Combo box control, there is a property called InputTextPlaceholder. By default, this property will appear with a hint text as “Find Items“. By using this property, you can change the text that you want including the inverted comma (“”) as shown below.
PowerApps dropdown hint text

PowerApps html dropdown

Do you need to insert the dropdown value in PowerApps HTML content? Then, check out this below code.

  • Lets say in the app, there is a html form and the data source has connected to a SharePoint List. Here, I would to like to email out the data to specific people.
  • There is a Dropdown control in the form and I want to specify this control selected value in the HTML content. To do so, you can follow this below code:
"<b>This is the text that you want to specify: </b>"&" "&Text(DataCardValue35.Selected.Value)&"</br>"

Where,

DataCardValue35 = Dropdown control data card

  • Suppose, the dropdown control is present outside of the form, then instead of the dropdown data card value, you need to put the dropdown control name as like “Dropdown1.Selected.Value“.

PowerApps hover dropdown

  • While working with the Dropdown menu, many of the PowerApps Users may think that is there any way to create a hover or mouse over control?
  • Now coming to the answer of this question is, No, there is no way to create a hover on the dropdown text. Also, it is not possible for a Power Apps Combo box control.

PowerApps hide dropdown value

Do you ever think that we can hide the choice value from the Dropdown control? Yes, we can hide or remove the unwanted option from the PowerApps Dropdown control. You can refer to the below code to hide the option.

  • In the below screenshot, you can see there is a Dropdown control where all the choice values are retrieved from the SharePoint choice field. The choice values are Approved, Pending, Rejected and Submitted.
  • Now in the dropdown menu, I would like to hide a unnecessary value i.e. Submitted as shown below.
PowerApps hide dropdown value
  • To workaround this, Select the Dropdown control and apply this below formula on its Items property as:
Items = Filter(
    Choices('Project Details'.'Project Status'),
    Value <> "Submitted"
)

Where,

  1. ‘Project Details’ = Sharepoint List Name
  2. ‘Project Status’ = SharePoint Choice column name
  3. “Submitted” = Specify the choice option that you want to hide
Power Apps hide dropdown value
  • Once you will save and preview the app, you can see the specified unwanted value has disppeared from the dropdown menu.

Also, you can refer to the below tutorial for more Dropdown examples:

Show hide fields based on dropdown selection PowerApps

PowerApps dropdown if statement

In this scenario, We will see how to work with the If statement in the Power Apps Dropdown control. Just try out the below example.

  • There is a Dropdown control having with these below items as:
  1. IT
  2. HR
  3. FINANCE
  • Also, there is a Text input control in the app. Here what I want to do is, when the user will select the dropdown value as FINANCE, then only the text box will appear otherwise it will be in hidden mode.
  • To do this, select the text input control and apply this below code on its Visible property as:
Visible = If(
    Dropdown28.Selected.Value = "FINANCE",
    true,
    false
)

Where,

  1. Dropdown28 = Dropdown control name
  2. FINANCE = Specify the dropdown value. The specified value must match with the dropdown control value
PowerApps dropdown if statement

Also, you can refer to these below Power Apps links to work with the If statements in PowerApps:

  1. PowerApps if statement with examples
  2. PowerApps CountIf Function with Examples
  3. PowerApps CountRows function with Examples
  4. PowerApps Count Function with Examples

PowerApps dropdown lookup

Do you want to work with the SharePoint Lookup field in PowerApps Dropdown control? You can refer to the below scenario.

  • There is a SharePoint List called Shopping Cart. This list has various columns like Cart ID, Title, Price, Color (it’s a Choice field). Among all these columns, there is one lookup column named Product (the values are retrieved from another list).
  • Here, I would like to compare this Product lookup field with the other fields like Title, Color, etc.
PowerApps dropdown lookup
  • The below screenshot represents the requirement that I wants to do. There are two Dropdown controls one for Product and other one for Title.
  • The Product dropdown is the lookup value that are retrieved from the list. Here what I want to do is, When the user will select any lookup value from the product dropdown, then the related title of that product will display in the text box control. As here I am going to compare the lookup field with the Title field.
Power Apps dropdown lookup
  • The Product dropdown menu is having the below code on its Items property as:
Items = Choices('Shopping Cart'.Product).Value

Where,

Product is the Lookup field in the Shopping Cart list.

Power Apps dropdown lookup field
  • To compare it with the Title field, insert a Text input control and set its Text property to this below code as:
Text = LookUp(
    'Shopping Cart',
    Product.Value = Dropdown26.Selected.Value,
    Title
)

Where,

Dropdown26 = Dropdown control name

powerapps dropdown lookup field
  • Similarly, suppose you want to compare the lookup field with a SharePoint Choice field, then in that case, you can try this below code:
Text = LookUp(
    'Shopping Cart',
    Product.Value = Dropdown26.Selected.Value,
    Color.Value
)
  • You need to specify the choice field with “.Value” option. Otherwise you may face some error in the code. You can follow the below screenshot.
powerapps dropdown lookup fields

To learn more about PowerApps Dropdown Lookup, you can check out the below tutorial:

PowerApps SharePoint Lookup Column + PowerApps Dropdown Example

PowerApps dropdown limit

  • Whenever you are working with PowerApps Dropdown control, you should know there should be a certain limit to that control. That means the user should know the limit that how many items can be held by this control.
  • So coming to the answer is, A Power Apps Dropdown control can hold only 500 items, not more than that.
  • Suppose in your Data source (maybe an Excel or a SharePoint List), there are more than 500 items and you want to display the items in a Dropdown control. So in this case, you can display the items upto 500. If the limit is exceeded 500, then an error message will appear as “Maximum number of items reached”.
  • To overcome this, alternatively what you can do is, you can use a Combobox control instead of the Dropdown control. There is no limit for the Combobox control in PowerApps.

PowerApps dropdown list of users

  • Suppose you want to display all the user list in a Powerapps Dropdown control. If it is your requirement, then there will be some difficulties that can occur by the control like the dropdown menu may not be show any values or return only the blank values etc.
  • Also, the dropdown control has the limitation issue that the items can not be exceeded more than 500.
  • So the best thing you can do is, you can take a Gallery control and there you can use filter and Office365Users function to perform the action as like the below scenario. That will be easy for us.

Example – 1: (Display Gallery with all users)

  • Insert a Gallery control and apply this below formula on its Items property as:
Items = Filter(
    Office365Users.SearchUser(),
    DisplayName <> Blank()
)
PowerApps dropdown list of users
  • Once you will save and preview the app, you can see all the list of users will appear in the gallery control as shown above.

Example – 2: (Display Gallery based upon the Search text)

  • There is a Text input control where you can search the names of any user. When you will start to search with the first alphabet, then the gallery will display all the alphabet-related names.
  • For example, Suppose in the text box, I want to search the name as Bijay. So when I will enter the letter B, then the gallery will show me all the user names that are starting with B only.
  • To workaround this, select the Items property of the Gallery control and apply this below code:
Items = Filter(
    Office365Users.SearchUser(
        {
            searchTerm: TextInput2.Text,
            top: 5
        }
    ),
    DisplayName <> Blank()
)

Where,

TextInput2 = Text input control name

Power Apps dropdown list of users
  • Save and Preview the app. Enter the user name in the text input box, then you can see all the related names in the gallery control.

To know more about People picker in PowerApps, you can refer to the below article:

Create People Picker in PowerApps with Combo Box

PowerApps dropdown not working

While you are working with the Dropdown menu, in some cases, you may face some issues. There are certain cases where Power Apps Dropdown control can not work properly. To overcome some type of issues, you can try these below solutions:

  1. Issue:
  • Some times what happens is, When we are publishing the app, Dropdowns are not appearing in the Edit form.
  • For this, What we are doing is, we are going back to edit mode again and refreshing the data source again. Then the dropdown is showing in the form.
  • But once we are saving publishing the app again, then the specific dropdowns are disappearing.

Its Solution:

To overcome this, We need to ensure two things i.e.

  1. We need to make sure the DisplayMode property of the Dropdown box is set to the following:
DisplayMode.Edit

We will use DisplayMode.Edit rather than DisplayMode.View

2. Also, we need to make sure the edit form is in Edit mode rather than the View mode, and your form is an Edit form rather than a Display form. Set the DefaultMode property of the Edit form to the following:

FormMode.Edit

We will use FormMode.Edit rather than FormMode.View

  • Other than that what you can do is, remove the data source connection from your app, then re-create a new connection to your data source from your app, then may be the issue will resolve.

2. Issue:

In some cases, the Dropdown control works perfectly in the edit mode and when we are clicking on the submit or play button, there are no options populates in the published app. This is a common issue for all PowerApps users.

Its Solution:

  • To overcome this issue, We need to disable an option called Explicit Column Selection. Open File tab -> Settings -> Upcoming features -> Click on Preview section -> Toggle off to the Explicit column selection as shown below.
  • Once you will set this feature to off, then you may see the difference.
PowerApps dropdown not working
  • Other than this, what you can do is, you can clear your Browser cache and maybe the issue will resolve.

PowerApps dropdown onchange set variable

Do you know how to set a variable on the PowerApps Dropdown control and use the variable anywhere? Check out the below things to do so.

  • In the below scenario, I want to change the value of the dropdown control when the user selects it. Also, the OnChange value will appear in a Label control.
  • I have a Dropdown control having with these below items as:
Items = ["Burj Khalifa", "Eiffel Tower", "Empire State Building", "Hagia Sophia", "Colosseum"]
PowerApps dropdown onchange set variable
  • Select the Dropdown and set this below code on its OnSelect property as:
OnSelect = UpdateContext({BuildingVariable: Dropdown29.Selected.Value})

Where,

  1. BuildingVariable = Context variable name
  2. Dropdown29 = Dropdown control name
Power Apps dropdown onchange set variable
  • Now, Insert a Label control and set this variable on its Text property as:
Text = BuildingVariable
PowerApps drop down onchange set variable
  • Save and Preview the app. Select one Dropdown value, then you can see the label will appear with the new value. When you are again going to change the value, then only the label will display with the onchange value.

PowerApps dropdown overflow

  • Sometimes in some cases what happens is, the dropdown options and the labels are cutting off in the form or in the app. That means, simply we can say is overflowing in the dropdown control.
  • As you may know, there is no Wrap property in the PowerApps Dropdown control. So to overcome this, you can refer to the below link that I have found from browser:

PowerApps Dropdown Options & Labels Are Cutoff

PowerApps dropdown remove blank value

Is there any blank value present in your Dropdown control or do you want to remove any unnecessary blank value from the Dropdown control? Please check out this below formula that how you can work with PowerApps dropdown remove blank value.

Filter(Choices('Your SP List'.'Column Name'), Not(IsBlank(Value)))

Or you can try,

Filter(Choices('Your SP List'.'Column Name'), !IsBlank(Value))

The above formulas always return a table of items that do not have blanks.

PowerApps dropdown search

  • Some of the PowerApps users (may be beginneres) may think that, is there any way to search items or options in a dropdown control.
  • So there is no such feature of Power Apps Dropdown control where you can search any item. Rather than you can use a Power Apps ComboBox control that can be work better. By using a combobox control, users can search the contents by typing into it.
  • Also, you can refer to the below PowerApps tutorials to understand better:

PowerApps Search using a Drop-Down Input Control

PowerApps dropdown sort distinct

In this scenario, We will see how to work with PowerApps dropdown sort distinct function. Let us discuss the below examples.

Example – 1:

  • There is a SharePoint List called Gadget Details. In this list, there is a column (Single line of text) named Brand.
  • In PowerApps, I want to sort this column with distinct values and the result will display in a Dropdown control.
  • To do so, select the Dropdown control and apply this below code on its Items property as:
Items = Distinct(
    Sort(
        'Gadget Details',
        Brand
    ),
    Brand
)
  • When you will apply the above code to the dropdown control, the result always returns with an ascending order as shown below..
PowerApps dropdown sort distinct

Example – 2:

  • Also, there is an another way to use the sort distinct function in the PowerApps Dropdown control. By using the below code, you can specify the order (Ascending or Descending) of the dropdown values.
  • Select the Dropdown control and set its Items property as:
Items = Sort(
    Distinct(
        'Gadget Details',
        Brand
    ),
    Result,
    Descending
)

Where,

Descending = Specify the order for dropdown values that you want to display

Power Apps dropdown sort distinct
  • Once you will save and preview the app, you can see the dropdown values will appear with the decending order as shown in the above screenshot.

PowerApps dropdown transparent

In this scenario, We will check out how to work with transparent in the PowerApps Dropdown control.

  • Here what I would like to do is, when I will select or hover any value from the dropdown menu, it will appear with a transparent background and when untouched, then the dropdown will appear with a solid level background.
  • For this, We will use the OnChange property of the Dropdown control where we will create a context variable. Select the Dropdown menu and apply this below code on its OnChange property as:
OnChange = UpdateContext({Switch: true})

Where,

Switch = Context variable name. You can specify the variable with any name that you want.

PowerApps dropdown transparent
  • Next, under the Fill property of the Dropdown control, set the below formula as:
Fill = If(
    Switch,
    RGBA(
        0,
        0,
        255,
        0.8
    ),
    RGBA(
        0,
        0,
        255,
        0.2
    )
)

Where,

Switch = specified variable name

Power Apps dropdown transparent
  • The above two codes specifies it would make the Dropdown to stay at 20% transparent of the RGBA, and once the dropdown changed its value, it will change to 80%. You can also provide the color (for over and solid background) as per your wish.
  • Save and Preview the app. Hover over one value from the dropdown control, then you can see it will appear with the provided transparent background and once you will untouch it, it will revert into the solid blue color as like the below screenshot.
PowerApps drop down transparent

PowerApps dropdown to radio

Do you want to change the PowerApps Dropdown control to the Radio button control? Follow the below process that how you can do.

  • In the app, there is an Edit form where the fields are retrieved from the SharePoint List named Shopping Cart. This list has a Choice field called Color having with different types of choice options.
  • In the form, this choice field appears with a Combobox control (by default). I would like to convert this control to a Radio button control.
PowerApps dropdown to radio
  • At first, Unlock the data card. Remove the Dropdown data card value and insert a Radio button. When you will remove the dropdown data card, some error will appear in the data card properties like its Height and Width. To avoid the error, remove the unwanted code from those properties.
  • Select the Radio button and set this below code to its Items property as:
Items = Choices('Shopping Cart'.Color)
Power Apps dropdown to radio
  • Next, set the Default property to the below code as:
Default = ThisItem.Color.Value
PowerApps dropdown to radio button
  • At last, Select the Data card and apply this below formula to its Update property as:
Update = Radio1.Selected

Where,

Radio1 = Name of the Radio button control

PowerApps dropdown control to radio button
  • Save and Preview the app. Now you can see the Dropdown menu has changed to PowerApps Button control and you can use it based upon your requirement.

PowerApps dropdown validation

Do you want to validate the PowerApps Dropdown control? Check out the below example.

  • In this example, there is a Dropdown control having some choice options including a blank choice. Also, one text input control is there that helps to display a warning message to the user when the user will choose the blank value from the dropdown menu. Refer to the below screenshot.
PowerApps dropdown validation
  • In the below screen, you can see the Dropdown control is having with these below values on its Items property as:
Items = [
    Blank(),
    "Lionel Messi",
    "Cristiano Ronaldo",
    "Xavi"
]
Power Apps dropdown validation
  • Next, Select the OnSelect property of the Dropdown menu, remove the boolean value (false) and make it as blank as shown below.
Power Apps drop down validation
  • At last, select the text input control and set this below code to its Visible property as:
Visible = IsBlank(Dropdown34.Selected.Value)

Where,

Dropdown34 = Dropdown control name

dropdown validation in PowerApps

Refer to the below PowerApps article to know more details about Validation in PowerApps.

PowerApps Validation

PowerApps dropdown with all

In this topic, We will see how to work around with PowerApps dropdown with all. Let us take a simple example.

  • Suppose in the dropdown control, you want to select all the choice values instead of choosing each item. At first, I would like to suggest taking a Combo box control instead of Dropdown control.
  • The Combobox control is having the items that are retrieved from a SharePoint column (Brand). Here, I would like to have “Select All” in my Category drop-down choice.
  • To achieve this, first, We will create a Collection on the App’s OnStart property as:
OnStart = ClearCollect(
    BrandCollection,
    {Result: "Select All"},
    Sort(
        Distinct(
            'Gadget Details',
            Brand
        ),
        Result
    )
)

Where,

  1. BrandCollection = Collection name
  2. Gadget Details = SharePoint List name
  3. Brand = SharePoint Column name (single line of text)
PowerApps dropdown with all
  • Now, set the created collection name to the Dropdown’s Items property as:
Items = BrandCollection
Power Apps dropdown with all
  • At last, Save, Publish and close the app. Reopen the app again. Then you can see there will be a choice named “Select All” in the combo box control. You can click on it to select all the values from the Combobox.
PowerApps drop down with all

You can refer to the below PowerApps tutorial to work with ForAll Function:

PowerApps ForAll Function with examples

PowerApps dropdown yes no

Here we will see how we can use the PowerApps dropdown with SharePoint Yes No field. In this scenario, I would like to display all the SharePoint yes no field values in a Dropdown menu.

  • Below represents the SharePoint List named Shopping Cart. This list has a Yes/No field called IsReceived.
  • There are some records where some of them are having the Yes/True value and some of them are No/False. And I want to show all the yes no values of each record in a PowerApps Dropdown control.
PowerApps dropdown yes no
  • Select the Dropdown control and apply this below code on its Items property as:
Items = Filter(
    AddColumns(
        'Shopping Cart',
        "hideVal",
        Hide
    ),
    !hideVal
).IsReceived
  • In the above code, I have added a column to the results from the Shopping Cart list called hideVal and then set it to the value of the Hide yes.no column.
  • The reason behind doing this is because the Filter function in PowerApps still does not filter true or false values properly.
  • That’s why I have used this little trick where I have created a new column in the results that will truly have the true or false value of the yes/no column. Refer to the below figure.
Power Apps dropdown yes no
  • When you will save and preview the app, you can see the result in the dropdown control as shown below.
PowerApps drop down yes no

PowerApps dropdown year

In this topic, We will see how to work with the Year in a PowerApps Dropdown control. Follow these below scenarios.

Example – 1:

  • The first thing you can try out is by giving the value as manually. What you can do is, select the Dropdown control and set its Items property to the below code:
Items = ["2018", "2019", "2020", "2021", "2022", "2023"]
  • You can specify the number of year that you want to display in the dropdown menu. But the thing is, you should enter it as manually.
  • Suppose you have a SharePoint List and the list has a Year column. The year column contains a set of years and you want to display this field in a Dropdown control.
  • To do this, Set the Dropdown’s Items property as:
Items = 'SharePointListName'.YearColumnName

Example – 2:

  • In some cases, you may think that is there any other way where we can populate a dropdown control with a set of years and also that should not be entered as user manually?
  • Yes, there is a simple code that can use to get some set of years in a Dropdown control. Write the below code on Dropdown’s Items property as:
Items = [
    Year(Today()) - 3,
    Year(Today()) - 2,
    Year(Today()) - 1,
    Year(Today()),
    Year(Today()) + 1,
    Year(Today()) + 2,
    Year(Today()) + 3
]
  • Here, by using the above code, we will get the year only from 2018 to 2024. Also, you can increment or decrement the value as per your need.
  • One important thing you make to ensure is, the above code will work only in a Dropdown control not in a Combo box control. Refer to the below screenshot.
PowerApps dropdown year
  • Once you will save and preview the app, you can see all the set of years in the dropdown menu as shown below.
Power Apps dropdown year

Example – 3:

  • Suppose you want to set the Default value of the dropdown control to the current year. Then in this what you can do is, use a Combo box control instead of a Dropdown.
  • Select the ComboBox control and apply this below formula on its DefaultSelectedItems property as:
DefaultSelectedItems = {
    '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
    Value: Text(
        Now(),
        "yyyy"
    )
}
show year in PowerApps dropdown
  • When you will apply the above code, you can see the current year will display as by default in the combobox control.

Also, you may like the below PowerApps tutorials:

In this PowerApps tutorial, We discussed Dropdown control in PowerApps, What are the properties, and how to use Dropdown control in PowerApps.

Also, By taking some simple scenarios, We covered the below topics:

  • PowerApps dropdown add items
  • PowerApps dropdown add empty value
  • PowerApps dropdown values
  • PowerApps dropdown selected value
  • PowerApps dropdown default value
  • PowerApps dropdown blank default
  • PowerApps dropdown default selected value
  • PowerApps dropdown items manual
  • PowerApps dropdown multiple select
  • PowerApps dropdown multiple columns
  • PowerApps dropdown based on another dropdown
  • PowerApps dropdown binding
  • PowerApps dropdown items from sharepoint list
  • PowerApps dropdown choices from sharepoint list
  • PowerApps dropdown person field
  • PowerApps dropdown selected value to text
  • PowerApps dropdown set selected value
  • PowerApps dropdown concatenate values
  • PowerApps dropdown filter
  • PowerApps dropdown collection
  • PowerApps dropdown clear selection
  • PowerApps dropdown column names
  • PowerApps dropdown distinct values
  • PowerApps dropdown remove duplicates
  • PowerApps dropdown email
  • PowerApps dropdown groupby
  • PowerApps dropdown hours
  • PowerApps dropdown hide chevron
  • PowerApps dropdown hint text
  • PowerApps html dropdown
  • PowerApps hover dropdown
  • PowerApps hide dropdown value
  • PowerApps dropdown if statement
  • PowerApps dropdown lookup
  • PowerApps dropdown limit
  • PowerApps dropdown list of users
  • PowerApps dropdown not working
  • PowerApps dropdown onchange set variable
  • PowerApps dropdown overflow
  • PowerApps dropdown remove blank value
  • PowerApps dropdown search
  • PowerApps dropdown sort distinct
  • PowerApps dropdown transparent
  • PowerApps dropdown to radio
  • PowerApps dropdown validation
  • PowerApps dropdown with all
  • PowerApps dropdown yes no
  • PowerApps dropdown year
>