Forum Discussion
Janna Jacobson
Sep 18, 2017Brass Contributor
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!
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 DentonSteel 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.
- Janna JacobsonBrass Contributor
Tanya - are you in Outlook 2016? I do not see that column at all.
- Tanya DentonSteel Contributorno Excel 2016