How To Extract Record Field Values From Lists

For today’s video, I’d like to demonstrate how you can extract record field values from nested lists and combine those into a single text string.

Melissa

***** Video Details *****
00:00 Introduction
00:25 The problem
01:13 Reference source query
01:22 Create custom column
01:36 List.Transform
02:28 lookupvalue
04:09 Text.Combine

***** Learning Power BI? *****

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #PowerQuery #PowerQueryTutorial

[nigelvenables]

Wow, this is exactly what I spent many hours trawling the internet to fix, I have lookup columns in Sharepoint and they were coming through a Lists in PowerBi and I couldn't figure out to extract the values until I watched this, thanks for uploading!

[katiekaaay]

Wow this was exactly what I needed, thanks!

[corroprapostar]

Hi Melissa!

Congratulations on the content! You saved me! :)
I live in Brazil and I could only find your video with this explanation. Thank you very much!

[raimundojs]

Very useful, perfectly explained solution. And a smooth beautiful voice, as a bonus. Thank you for sharing! Great Power Query playlist!

[nickcorbin]

When I watched this a few months ago it was interesting even though I hadn't encountered the specific situation. Fast forward to today and this exact problem cropped so hurrah for this absolutely fantastic content!

[DewayneBridges]

Thanks SO MUCH, had to watch a few times since my lists were choices from Sharepoint instead of records, but got it to work. REALLY APPRECIATE IT!!!

[dhyrumc]

Fantastic Video!! That was super helpful and really helped me understand how Power Query thinks about Lists and Records. Not to mention it solved my problem :)

[alexb]

Thank you so much ! I was so stuck in my code. Thks to you, I can continue !

[hoanglam]

Thank you so much, looking for this for 2 months😀

[kebincui]

Thanks Melissa. Is it okay if we use the function of Record.Field rather than Text.From for this case?

[raeesahamed]

Very informative Melissa!. In my task case, i have a nested list. Its like list -->record -->list -->record-->values. How to get these value. Please help.

[JenMayB]

Thank you so much. I’m having a problem because it’s not a record within a list that I have the list within a list that I have and I just keep getting errors no matter how I try to write the code.

[fernandoaraujo]

Hello. Thanks for this upload. But how can I retrieve the record value if the first column is not fixed? In my case it can be any number between 1 and 10, instead of "lookupvalue". Thanks a lot!

[mirrrvelll]

Great video! What is the purpose of "?" actually?

[fabz]

Good tutorial!
I am currently struggling with records nested in records... Like I have a list of records and in these records there are also records. Anybody knows how to extract the value of these nested records?

[sabrinahuda]

Hi there, i have a question. If we import data using sharepoint online list and perform this step to extract the record field values, is the values will sync to the sharepoint? like if anything change from the sharepoint list, and when refresh the data will update from the latest one ?

[tigere]

How do you skip to end when intellisense auto adds closed brackets. I always have to delete close bracket then add it manually after text

[hectorgarcia]

I have the same situation but the list contains 5 records with questions and answers that I need transform the questions into columns and answers into rows, how can I do that?

[wizit]

This video might only have 66 likes, every one of those likes are from people that just had their butts saved lol. Exactly what I was looking for and solved my problem, thank you!!!