Forum Discussion

jcastr02's avatar
jcastr02
Icon for Post Prodigy rankPost 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]...
Need Help
TomMartens's avatar
TomMartens
Icon for Super User rankSuper 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
Icon for Post Prodigy rankPost 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.