Select Columns in a nested Table, based on a list of column name

[AlexGT92]

Hello 

I am trying to select few columns in a nested Table. I have defined the columns name to be selected in a list in a previous step.

I tried Select.Columns and List.Contains but because the data is in a nested column the formulas dont work.

here is the code I have at the moment

=Table.AddColumn(PreviousStep, "SelectColumn", each List.Contains(ListColumn,[NestedTableColumn])=true)

Could you please help me on this ?

[Galvafan]

hi guys sb found a solution? I have similar problem. I tried below but not working.

= Table.TransformColumns(previous_step, {"Skip", each _fx_SelecionaColunas([Skip], [ColNames])})

((((_fx_SelecionaColunas))) =
(tbl as table, col_with_list as list) =>
let  selected_columns = Table.SelectColumns(tbl, col_with_list)  in selected_columns 

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[Galvafan]

hi guys sb found a solution? I have similar problem. I tried below but not working.

= Table.TransformColumns(previous_step, {"Skip", each _fx_SelecionaColunas([Skip], [ColNames])})

((((_fx_SelecionaColunas))) =
(tbl as table, col_with_list as list) =>
let  selected_columns = Table.SelectColumns(tbl, col_with_list)  in selected_columns 

[lbendlin]

your code is missing a few bits and pieces.  What exactly are you planning to put into "SelectColumn" ?  a single column value, or a collection of columns?

[AlexGT92]

Hi, Select Column is the new table name where I have some of the columns from the previous step. I would like to select few of the columns from the previous table. And this selection should be based on a list (with column names).

[lbendlin]

Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.