Power Query Parameters

[dicken]

Hi,
if you use the option to use a query as the ' suggested value' what does it do,
I created a query = {"A","B","C", "D"} ,

and put this into the suggested value for new parameter and A; it does not give a list , B; it does not restrict the values I can enter manually to
one from that list,
so in the below I could enter any value I like or null. so what does it do? I

=

Table.SelectRows(Custom1, each ([#"Ttable "] <> parameter))

Richard

 

[RoryA]

In PQ Online, it works a bit like the list option, but it's dynamic - so you get a list of options to choose from when managing the parameter. That doesn't seem to be implemented in PQ in Excel, at least not in my version.

 

[dicken]

Thanks,

Richard.