Power Query M Code - Select Columns if the Header contains two specific values

[ajay_gajree]

= Table.SelectColumns(Source,{"51a", "51b", "51c", "51d", "51e", "51f", "51g", "51h", "51i", "51k", "Entry Id"})

Hi all

I have the above M Step, is there a way to dynamically code this so that I pick up all column headers that contain 51 and additionally Entry Id?

Best regards

Ajay

[v-alq-msft · Accepted solution]

Hi, @ajay_gajree 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Table:

You may add a new step with the following m codes.

= Table.SelectColumns(
         #"Changed Type",
         List.Combine({
         {"Entry ID"},
         List.Select(
                Table.ColumnNames(#"Changed Type"),
                each Text.Contains(_,"51")
         )
         })
)

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Use Table.ColumnNames() to get the list and then remove everything from the list that doesn't match your requirements.  Then use the remaining list in the Table.SelectColumns() statement.

[vic24he]

How do you pass a list into table.selectcolumns? When I pass my list into the function it gets:

Expression.Error: We cannot convert a value of type List to type Text.
Details:
Value=[List]
Type=[Type]

[lbendlin]

Please show the relevant portion of the Power Query code.