Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
e_pfef
New Member

Extract value from a list of records

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. 

e_pfef_0-1728421535138.png

e_pfef_1-1728421578735.png

e_pfef_2-1728421698772.png

 

 

1 ACCEPTED SOLUTION
PhilipTreacy
Super User
Super User

@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

 

PhilipTreacy_0-1728434176215.png

 

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

 

 

 

 



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

2 REPLIES 2
PhilipTreacy
Super User
Super User

@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

 

PhilipTreacy_0-1728434176215.png

 

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

 

 

 

 



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Omid_Motamedise
Super User
Super User

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

 

If my answer helped solve your issue, please consider marking it as the accepted solution. It helps others in the community find answers faster—and keeps the community growing stronger!
You can also check out my YouTube channel for tutorials, tips, and real-world solutions in Power Query with the following link
https://youtube.com/@omidbi?si=96Bo-ZsSwOx0Z36h

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.