Get values from the List column

[Derek-R]

Hi All,

I have done Power BI and jira integration usign Rest API's and the data in few columns in the queries store Record and List values. How can I retrieve data from List values?

Thanks 

[Derek-R]

Just adding few screenshots for the explanation:

The Column name is "Components" which has List values and below is the record 

How can I retreive the name from here and store it in a new column in the query?

Thanks

[v-shex-msft]

Hi @Derek-R,

I'd like to suggest you add a custom column with nested M query functions.

You can extract the current row as source of following operations to convert it to table. Then you can nest previous result with 'Table.Transpose' to convent the rows to columns and use the first row as table column names.

Transpose table - Power Query | Microsoft Learn

Promote or demote column headers - Power Query | Microsoft Learn

After these steps, you can do expand on this field to expand the transformed table contexts.

Optimize Power Query when expanding table columns - Power Query | Microsoft Learn

Reference documents:

Table.Transpose - PowerQuery M | Microsoft Learn

Table.PromoteHeaders - PowerQuery M | Microsoft Learn

Regards,

Xiaoxin Sheng