expand list in table.

[Shruthi96]

Hi Folks, 

Need help..

In the below snapshot, I need to get records from account name by expanding the column. I need to get each account name with comma seperated. 

I get error, "Expression.Error: We cannot convert a value of type Record to type Text." If you observe below snapshot, it contains three values, lookupid, loopkvalue and isSecretFieldvalue. 

My inetrest is only "lookupValue" where it contains account name.  I need to tweak below line, 

= Table.TransformColumns(#"Extracted Values3", {"Account Name", each Text.Combine(List.Transform(_, Text.From), ","), type text})

Thanks in advance. 

[amitchandak]

@Shruthi96 , Click in the empty space near to list and check what kind of data it has. Based on that we can do the operation needed, Seem like the current operation is not suitable.