Others

How to Prevent Duplicate Selections in Two Power Apps Dropdowns

Maira Mehtab Sep 22, 2026 869 views

Question details

The user wants to configure two dropdown controls so that selecting an option in the first dropdown dynamically removes it from the available options in the second, and vice versa.

Product: Microsoft Power Apps
Device & OS: not provided
Scenario: Building a custom application where users need to make unique selections across multiple dropdown menus from the same data source.
Observed behavior: The goal state is to successfully filter the Items property so that duplicate choices are restricted across two connected dropdown controls.

Before you start

Ensure you have the appropriate edit permissions for the Power Apps canvas app and note down the exact data source name that supplies your dropdown options.

Solution 1Recommended

Apply Cross-Filtering to the Dropdown Items Property

Modify the Items property of both dropdown controls to filter out the value currently selected in the other control.

Power Apps allows you to dynamically alter the list of choices in a dropdown by using the Filter function. By checking the selected value of the opposite dropdown, you can ensure the lists never overlap.

Select the second dropdown

Click on your second dropdown control (e.g., Dropdown2) on the app canvas and navigate to the 'Items' property in the formula bar.

Update the formula for the second dropdown

Change the formula to `Filter(Options, Value <> Dropdown1.Selected.Value)`. Replace 'Options' with your actual data source name and adjust the control names as needed.

Select the first dropdown

Click on your first dropdown control (e.g., Dropdown1) and find its 'Items' property.

Update the formula for the first dropdown

Change its formula to `Filter(Options, Value <> Dropdown2.Selected.Value)` to apply the reverse filter.

Preview and test

Hold the Alt key or press the Play button to preview your app. Verify that selecting an item in one dropdown successfully removes it from the other.

Handling Circular References: If you receive a circular reference warning from Power Apps, you may need to use variables to store the selected values using the OnChange property, rather than referencing the controls directly.

Free Microsoft Office alternative

Boost Your Productivity with WPS Office

While Power Apps is excellent for building custom app interfaces, managing the underlying spreadsheet data sources requires a robust office suite. WPS Office provides a lightweight, highly compatible alternative to Microsoft Office for organizing and cleaning all your app's data sources.

1. Download WPS Office: Get the free WPS Office suite from the official website and install it on your device.
2. Open Your Data Source: Open the Excel spreadsheet that feeds your Power Apps options directly in WPS Spreadsheets.
3. Manage Data Easily: Edit, format, and structure your dropdown options seamlessly using the highly compatible interface.

Fully compatible with Microsoft Excel (.xlsx) formats used for Power Apps data sourcesFree and lightweight alternative to Microsoft OfficeFamiliar spreadsheet interface with zero learning curve for data manipulationBuilt-in PDF tools and cross-platform synchronization

microsoft office alternative - wps office

Frequently Asked Questions

Can I apply this logic to more than two dropdowns in Power Apps?

Yes. For three or more dropdowns, you must chain the filter conditions using the 'And' operator. For example: `Filter(Options, Value <> Dropdown1.Selected.Value And Value <> Dropdown3.Selected.Value)`.

Why am I getting a delegation warning with the Filter function?

Delegation warnings occur if your connected data source does not support processing the not-equal (`<>`) operator on the server side. To resolve this, consider pre-loading the options into a local collection using the `ClearCollect` function on app start.

How do I clear the selected value so it reappears in the other dropdown?

You can use the `Reset(DropdownName)` function on a 'Clear' button or an `OnSelect` property. This clears the dropdown's selection, instantly making that item available again in the other control.

Office Quick Solutions