How can I keep data from a list of static column names plus two dynamic column names?

= Table.SelectColumns(#"Changed Type",List.Select(Table.ColumnNames(#"Changed Type"),each List.Contains({"Issue key", "Summary", "Status", "Resolution", "Components", "Labels", "Parent", "Custom field (Story Points)", "Custom field (Epic/Theme)", "Custom field (Resolution Category)"},_,(x,y)=>Text.StartsWith(y,x))))

Hi,

Thanks for the soluton wdx223_Daniel  provided, and i want to offer some more information for user to refer to.

hello petrawiggin , you can create a new step named custom1 and input the following code.

=Table.SelectRows(Table.FromList(Table.ColumnNames(#"Changed Type")),each Text.Contains([Column1],"Label") or Text.Contains([Column1],"Component"))

Then after the custom1 step  create a new step named custom2

={"Issue key", "Summary", "Status", "Resolution","Parent", "Custom field (Story Points)", "Custom field (Epic/Theme)", "Custom field (Resolution Category)"}&Custom1[Column1]

Then create a new step after custom2 named custom3

= Table.SelectColumns(#"Changed Type",Custom2)

Output

When I add new column named label 7 component 7 , then will both diplay.

Best Regards!

Yolo Zhu

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