Others

How to Create a Product Search Drop-Down in Power Automate

Maira Mehtab Sep 27, 2026 871 views

Question details

The user needs to create a product-name drop-down in a Power Automate instant flow that dynamically filters choices as characters are typed.

Product: Microsoft Power Automate
Device & OS: not provided
Scenario: Building an instant flow that requires dynamic user input with a searchable drop-down to filter product names efficiently.
Observed behavior: Looking for the appropriate control, trigger setup, and data filtering method to achieve search-as-you-type functionality within the flow.

Before you start

Before configuring your flow, ensure your underlying product database (such as a SharePoint list or formatted Excel table) is properly structured, indexed, and accessible to Power Automate.

Solution 1Recommended

Consult the Microsoft Power Platform Community

Since dynamically filtered search-as-you-type drop-downs involve advanced custom controls, leveraging the official Power Automate forums is the most effective way to get specific guidance tailored to your exact data source.

Native manual flow triggers in Power Automate offer basic drop-down functionalities, but true dynamic typing-based filters often require integration with Power Apps or specific API queries.

The dedicated Microsoft Power Platform Community provides direct assistance from community moderators and the Power Automate engineering team.

Visit the Community Forum

Navigate to the official Microsoft Power Platform Community and select the Power Automate forum from the directory.

Prepare Your Request Details

Gather the specifics of your current setup, including your data source (e.g., SharePoint, Dataverse, SQL), the control type you wish to use, and your initial flow trigger.

Post Your Question

Create a new topic detailing your need for a dynamically filtered product choice drop-down, providing the requested details so moderators can investigate and supply custom JSON or Power App integration steps.

Alternative Option: If you are using Power Apps as the front-end for your flow, you can utilize the 'ComboBox' control with the 'Searchable' property set to true to achieve this functionality before passing the data to Power Automate.

Free Microsoft Office alternative

Manage Your Product Databases Effortlessly with WPS Office

While automated cloud workflows require specialized tools like Power Automate, managing the underlying product lists and datasets is much simpler with a versatile office suite. WPS Office is a free, lightweight alternative to Microsoft Office that provides robust spreadsheet features, seamless format compatibility, and a highly familiar user interface for organizing your data.

1. Download and Install WPS Office: Visit the official WPS website, download the free suite, and complete the installation on your computer.
2. Open Your Product List: Launch WPS Spreadsheet and open the Excel or CSV file containing your product catalog.
3. Format Data as a Table: Select your product data range and format it as a table to ensure it cleanly integrates when imported as a data source into cloud platforms.

Easily organize product databases to feed into your automated workflowsExcellent compatibility with Microsoft Excel (.xlsx and .csv) formatsLightweight suite ensuring fast performance on any deviceCompletely free alternative to Microsoft OfficeFamiliar user interface requiring zero learning curve

Frequently Asked Questions

Can I add a searchable drop-down list directly in a standard Power Automate manual trigger?

Standard manual triggers in Power Automate offer basic static or dynamic drop-down lists but do not natively support typing-based search filtering. For search-as-you-type capabilities, you typically need to trigger the flow from a Power App or custom form.

What data sources work best for populating drop-downs in Power Automate?

Microsoft Dataverse, SharePoint Lists, and properly formatted Excel Tables stored in OneDrive or SharePoint are the most reliable and commonly used data sources for populating drop-down choices in automated flows.

How do I make my drop-down values dynamic in a flow?

You can dynamically populate a drop-down by using actions like 'Get items' (for SharePoint) or 'List rows present in a table' (for Excel) to retrieve the current data, and then mapping the required name/value pairs into the response or selection variables.

Office Quick Solutions