User Values from SharePoint showing up as [List]

[Anonymous]

Trying to build a report which feeds info from a SharePoint List

The column is a user value, which is a 'Person' column on SharePoint

I clicked into the column and selected 'Extract Values'

The error that comes up afterwards is 'Expression.Error: We cannot convert a value of type Record to type Text.'

When I click the value 'List' and enter 'Record', the name of the person appears under 'title', but I can't seem to get this feed into the list

Any assistance is greatly appreciated

[v-jingzhang]

Hi @Anonymous 

Can you show what is in the list with an image or a screenshot (remember to remove sensitive info)? Is it a list containing records? 

If your list column is similar to below and you want to extract names from all records in a list to the original table,

you can add a custom column with below code. You will get a list of title names on every row. Then expand it to new rows or extract values into the same cell per your need. 

= let titleList = [Column1] in List.Transform({0..(List.Count([Column1])-1)}, each titleList{_}[Title])

Sample table code:

let
    Source = {{[Title="Jack"],[Title="James"],[Title="Janey"]}},
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Added Custom" = Table.AddColumn(#"Converted to Table", "Custom", each let titleList = [Column1] in List.Transform({0..(List.Count([Column1])-1)}, each titleList{_}[Title]))
in
    #"Added Custom"

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.