Power Querry - adding multiple columns with values based on other query list.

[Radoslaw Poprawski]

Hi all,
so basicly:
I have a specified column names as list (can be a table aswell if needed)
Now I need to add those names into my query and populate based on some values from this query.

so to add multiple columns in 1 step i usualy use syntax:
=

 Table.AddColumn( #"Added Custom", "Record", each [
Col1 =  "A",
Col2 = "B"
...Col99999 -"ZZZ"
])

However when i replace Col1 and Col2 with syntax like:

Table.ColumnNames(MyQuery){0}

That returns a text value im getting an error:

So how do I fix this error?
Or how can add a columns from a list and populate it?
I would not want to to add 20 ,30 columns manualy, and this way it would be dynamic

 

[Radoslaw Poprawski]

any1?

 

[JGordon11]

maybe

Table.AddColumn( #"Added Custom", "Record", each Record.FromList({"A","B", ... "ZZZ"}, Table.ColumnNames(MyQuery)))

Where the list count of {"A","B", ... "ZZZ"} must equal the count of Table.ColumnNames(MyQuery)