Extract value from a list of records

[e_pfef]

Hi - I am new to Power BI / Power Query and all this so I will do my best to use the right verbage to explain my issue and what I need help with.

I have a column called "customFields", the column contains List which hold many Records and those hold values that I need from them. I am having trouble extracting the information from the records. 

Each List will have many Records, but not always the same amount, and not in the same order, which makes me think I'd need some kind of if-statement?

I need to break them out by 'name' and pull in the 'value' from a Record. I'm not sure what would be the best method to complete this if it's creating a different table or a new column or what. Any help is seriously appreciated. 

 

[PhilipTreacy · Accepted solution]

@e_pfef 

All you should need to do it extract the records from the lists using the double headed arrow at the top of the column.  When you click this, choose the option Expand to New Rows

You then have a column of records and can repeat the process.  Click the double headed arrow at the top right of the column and check the fields you want to extract (name and value?) and uncheck everything else.  You can also uncheck Use original column name as prefix 

You should now have the names and values from the records in separate columns.

Regards

Phil

[Omid_Motamedise]

It is hard to explain without accessing to the data but I think You can use List.Transfrom to solve this problem

see this video which give you the idea.

https://youtu.be/W-hTgciYtew?si=I3SsBSr-L0uZemRS