Forum Discussion
c2crane
Aug 20, 2019Copper Contributor
How to pass search Parameter for Power Query
How do I force the query to prompt for a parameter value to use to filter result?
- Aug 20, 2019
You can't prompt parameter to take it from input window field, but you could use some cell value in your sheet as parameter passing it to query. See, for example, https://www.excelguru.ca/blog/2018/05/30/creating-dynamic-parameters-in-power-query/
SergeiBaklan
Aug 20, 2019Diamond Contributor
You can't prompt parameter to take it from input window field, but you could use some cell value in your sheet as parameter passing it to query. See, for example, https://www.excelguru.ca/blog/2018/05/30/creating-dynamic-parameters-in-power-query/