Support for multi-value parameters
Important
This content is archived and is not being updated. For the latest documentation, go to Integrate data into Microsoft Dataverse. For the latest release plans, go to Dynamics 365 and Microsoft Power Platform release plans.
| Enabled for | Public preview | General availability |
|---|---|---|
| Admins, makers, marketers, or analysts, automatically | 
Jan 14, 2022 |
- |
Business value
This improvement to the query parameters feature in Power Query allows users to define parameters that take more than one value at once.
Feature details
Query parameters allow Power Query users to easily parameterize parts of their queries, like filter values, and easily update those parameter values in a centralized way (for example, when used across multiple queries).
Values in a query parameter can be either fixed/static (such as the value Shoes) or dynamic (for instance, the result of another query); however, a current limitation is that users can only pick a single value to be the parameter value (for example, shoes). An area of recurring customer feedback is the need to support the selection of more than one value. For example, a Product Category parameter could have Shoes, Shirts, and Accessories as the values of the parameter. This improvement addresses such a need and allows the user to define these parameters (called List parameters for list of values) through the Query Parameters user experience and downstream binding of these parameters (for example, Column1 in/not-in ProductCategory instead of the current Column1 = ProductCategory).