Forum Discussion

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...

BI & Data Analytics

Need Help

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

Steel Contributor

Sep 18, 2017

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.

Janna Jacobson
Brass Contributor
Sep 18, 2017
Tanya - are you in Outlook 2016? I do not see that column at all.
- Tanya Denton
  Steel Contributor
  Sep 19, 2017
  no Excel 2016
- SergeiBaklan
  Diamond Contributor
  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.
  - Janna Jacobson
    Brass Contributor
    Sep 18, 2017
    That did it! Thanks very much both of you!!