Forum Discussion
Extract data from List value column
Hi Anonymous ,
This is a blog on how to extract values from records and lists, I believe it will be helpful to you.
Extract Values From Records And Lists In Power Query - Master Data & AI Skills (enterprisedna.co)
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
That looks like a record. Try
= Components2{0}[name]
Pat
Hi ppm1 , It's a list. Please see below more screenshots.
When you click on List then below screen comes up:
In the colulmn header, click on the double arrow expand button and "expand to new rows". You should then have a column of Records. Click on the expand button on that column and choose only the name field.
Pat
Hi Anonymous ,
This is a blog on how to extract values from records and lists, I believe it will be helpful to you.
Extract Values From Records And Lists In Power Query - Master Data & AI Skills (enterprisedna.co)
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.