Forum Discussion

Janna Jacobson's avatar
Janna Jacobson
Brass Contributor
Sep 18, 2017
Solved

Where is SharePoint Document Library "Name" Column and Metadata?

I am trying to use Excel to pull a list of Documents from a Document Library in SharePoint Online. I can see a Title Column if I disable Content Management, but I cannot see the Name column even if I try to add the column after loading the initial Query. Also, metadata site columns are not showing. Any tips??  Thank you!

  • SergeiBaklan's avatar
    SergeiBaklan
    Sep 18, 2017

    Janna, use SPO site root URL for "From Sharepoint online list" connector, after that select the library you need, the field will be more close to the right side. Actually you may remove all other columns except FieldValueAsText, they usually not needed.

  • Tanya Denton's avatar
    Tanya Denton
    Steel Contributor

    I have just tried this with one of our document libraries that have metadata.  There was a field that when i expanded allowed me to see the MetaData fields and the 'name'.  Below is the field 'FileLeafRef' came me the name, then in this list you should see your metadata columns.

Resources