Forum Discussion

jcastr02's avatar
jcastr02
Post Prodigy
7 years ago

data shows [List] when extracting data from SharePoint

When I export data, the values for my table show as [List] for numerous entries.  How can I convert this to the true value?

 

LocationId

[List]
[List]
[List]
[List]
[List]
[List]
[List]
[List]
[List]
[List]
[List]
[List]
[List]
[List]
[List]
[List]
[List]
[List]
[List]
[List]
[List]
[List]
[List]
[List]
[List]

 

 

Need Help

2 Replies

  • TomMartens's avatar
    TomMartens
    Super User
    7 years ago

    Hey,

     

    basically this happens, when the source field of the sharepoint field is a multivalue field.

     

    I'm wondering if you can't expand the column in Power Query. There should be a sign next to the column name.

     

    Regards,

    Tom

    • jcastr02's avatar
      jcastr02
      Post Prodigy
      7 years ago

      Hi Tom,

       

      I don't see anything on the columns.  Just allows me to sort ascending, sort descending and then use the text filters.