Steps to Create A List Query From A Table Column

Power Query also allows you to create a list query from a data table available. The column from the given data table can be used to create a list query. This can be explained with the help of an example.

Creating A List Query From A Table Column

Here, we have a data table containing product details. We want to create a new query for the column ProductName from this data table. To do so, we need to follow the below steps.

Step 1: Select the Column for creating List Query

First, load the data table ‘Products’ into the Power Query. Then, select the column ‘ProductName’ from the data table as shown below.

Step 2: Create a List Query

To create a list query from the selected column, right click on the column and select ‘Add as New Query’ option as shown in the picture below.

 

NOTE: You can also use Table.ToList() function in Power Query (M) language for creating a list from a data table.

Step 3: Close & Apply

When you click on ‘Add as New Query’ option, Power Query immediately creates a new list Query for you as shown below. You can now Close & Apply the changes for the future.

You can learn more: 

• How to Manage Parameters in Power Query
• How to Create Grouped Serial Numbers In Power Query 
• Do Comments In Query Steps in Power Query
• Steps to Adding Comments In M in Excel