Forum Discussion
Advanced editor- Manage parameters which is obtained dynamically
Want the appropriate syntax in LIST to view the data (Azure SQL database). We have two parameters(list)- 'New' & 'New1". When we select the field from the parameter 'New', we execute 'Query 1' which shows the list. Now, we want to pass the values from executed 'Query1' to the 'New1' parameter in the form of list.
![1]: https://i.stack.imgur.com/3yoHL.png
Note:'Query1' is dynamically changes as we change the parameter.
Anonymous ,
According to your description, my understanding is that you are going to set the result of 'Query 1' as the values of Parameter 'New1'. We can use the Query List in Parameter to meet this requirement, but there is a limitation, when we change the parameter ‘New’, we need to apply the change first, then the new result will be returned to parameter ‘New 1’.Please refer to the following steps:
Firstly, we create a query (in my environment, it is named as Query1) with the parameter ‘New’, please refer to the following query:
let Source = Sql.Database("**", "**", [Query="**"&New]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"**", type text}}) in Table.ToList(#"Changed Type")Then we can create a new parameter with this list like below:
Regards,
Lydia
2 Replies
Anonymous ,
According to your description, my understanding is that you are going to set the result of 'Query 1' as the values of Parameter 'New1'. We can use the Query List in Parameter to meet this requirement, but there is a limitation, when we change the parameter ‘New’, we need to apply the change first, then the new result will be returned to parameter ‘New 1’.Please refer to the following steps:
Firstly, we create a query (in my environment, it is named as Query1) with the parameter ‘New’, please refer to the following query:
let Source = Sql.Database("**", "**", [Query="**"&New]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"**", type text}}) in Table.ToList(#"Changed Type")Then we can create a new parameter with this list like below:
Regards,
Lydia