Forum Discussion
Pass parameter from Cell(s)
Is there some way to pass a parameter to PQ from a value in a cell in the spreadsheet? Or prompt the user for values at runtime? Further, I used to use a tool when I worked with DB2 that would tak...
Exact solution depends on the data type of your list and what syntax your need.
BUT,
Lets say you have a table called Parameters and the column with the parameter values is called Values
The expression Text.Combine(Parameters[Values],”, ")
Will give you a text string of all you parameter values separated by commas.
This works for number values. If you need quotes, you probably need to add a custom column in your Parameters table to include the quotes first.