Forum Discussion
Referencing one parameter within another parameter within Power Query
Hi,
How do I reference one parameter within another parameter within Power Query...
For example I want to create a parameter representing an [Environment] representing the values "DEV", "UAT" and "PRD".
I also want to create another parameter representing the [Location] e,g, "www.mySales.com", "www.myPurchases.com", "www.myNominal.com"
The the third parameter references the first two parameters and is used in a data source definition.
Where for example the third parameter [FullPath] could equal "www.mySales.com\DEV" for instance.
So I was hoping to define the third parameter in the following way...
[FullPath] = [Location] & "\" & [Environment]
Can any one help?
Hi Kieran,
After defining the first two parameters, you must create a list by concatenating them.
let Source = Location& "\" & Enviroment, #"Converted to List" = {Source} in #"Converted to List"And then create the third parameter by choosing the Query option in Suggested Values, and this new list as Query.
Regards.
When you change any of the parameters you must apply changes to refresh the list that concatenates them, and then this value is refreshed in the third parameter, but you have to select this refreshed value by displaying the drop down for that parameter.
Regards.
3 Replies
Hi Kieran,
After defining the first two parameters, you must create a list by concatenating them.
let Source = Location& "\" & Enviroment, #"Converted to List" = {Source} in #"Converted to List"And then create the third parameter by choosing the Query option in Suggested Values, and this new list as Query.
Regards.
Hi,
When I change the first parameter and second parameter, the third parameter (based on the query option you stated) does not update to reflect the new contents of the first or second parameter,
LocationEnvironmentParameter
"www.myPurchases.com/UAT" meta [IsParameterQuery=true, ExpressionIdentifier=LocationEnvironmentList, Type="Text", IsParameterQueryRequired=false]
LocationEnvironmentList
let Source = Location & "\" & Environment, #"Converted to List" = {Source} in #"Converted to List"Location
"www.myPurchases.com" meta [IsParameterQuery=true, List={"www.mySales.com", "www.myPurchases.com", "www.myNominal.com"}, DefaultValue="www.mySales.com", Type="Text", IsParameterQueryRequired=true]Environment
"UAT" meta [IsParameterQuery=true, List={"DEV", "UAT", "PRD"}, DefaultValue="DEV", Type="Text", IsParameterQueryRequired=true]Any thoughts?
I wonder if this relates to the following issue ?
Kind Regards,
Kieran.
When you change any of the parameters you must apply changes to refresh the list that concatenates them, and then this value is refreshed in the third parameter, but you have to select this refreshed value by displaying the drop down for that parameter.
Regards.
