Advanced editor- Manage parameters which is obtained dynamically

[Anonymous]

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 · Accepted solution]

@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

[Anonymous]

what should be there @ place of 'source' and '**' in Table.TransformColumnTypes ?