Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

User Values from SharePoint showing up as [List]

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

 

 

Need Help

1 Reply

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    3 years ago

    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.