Extracting Title from SharePoint Online list

dgwilson 

Hi David,

To summarise, if you want to extract the title directly from the List use this code

#"Added Custom1" = Table.AddColumn(#"Added Custom", "Modified By", each try Record.Field([Outcomes Manager]{0}, "title") otherwise "")

To extract the Record from the List use this code

Transform = Table.TransformColumns(#"Added Custom", {{"Outcomes Manager", each if Value.Is(_,type list) then try _{0} otherwise "" else [title = "not assigned"], type record}} )

NOTE:  I've put a try..otherwise in there to allow for an empty list.

Examples of both of these are in this PBIX file.

Cheers

Phil

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.