Hello everyone,
Is it possible to create a parameter with the suggested values from the query that returns the column names from a table?
It seems Table.ColumnNames() returns the names of columns from a table as a text, because I don't see any drop-down list as an input value for the parameter.
Even with suggested values from any it does not work. Any suggestions?
Regards,
Is it possible to create a parameter with the suggested values from the query that returns the column names from a table?
It seems Table.ColumnNames() returns the names of columns from a table as a text, because I don't see any drop-down list as an input value for the parameter.
Code:
let
Source = Excel.CurrentWorkbook(){[Name="MasterTable"]}[Content],
#"Column Names" = Table.ColumnNames(Source)
in
#"Column Names"
Even with suggested values from any it does not work. Any suggestions?
Regards,