Forum Discussion
Referencing one parameter within another parameter within Power Query
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.
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.
