Forum Discussion
Can't find document Approval Status
Hi there,
I'm pulling data from a Sharepoint Document Library, but for some reason I am unable to find a field that reports the document's approval status (eg. draft, pending, approved). All of the other columns I need appear, but not that. Any advice?
Hi AlexJ01 - this is good question. In Power Query, there are 2 connectors
- SharePoint.Files - PowerQuery M | Microsoft Learn
- SharePoint.Tables - PowerQuery M | Microsoft Learn
You will use the first to content to SharePoint to find the Binary files in the [Content] column. When you content to the Site Collection please note that it will contain every document in that Site, so make use you use the FolderPath to select the correct Library and Folder.
Source = SharePoint.Files( #"URL for Site Collection" , [ApiVersion=15])
You can use the second to get SharePoint lists... and a Library is just a List of documents! This list will contain the properties like person, status, but it does not documents. When you use the below, you will be presented with a Table for all the elements in SharePoint, the Library should appear on the one of the rows. Just expand the Table to see the List perpective of the documents.Source = SharePoint.Table( "URL for Site Collection" , [Implementation="2.0"])The two tables can be joined using the Name of the document. Yes - it is annoying the GUID is not available in both result, so be careful with duplicates.
HI - it should appear on the SharePoint.Tables. You might need to change the "VeiwMode" to include all columns:
SharePoint.Table( URL, [Implementation = "2.0", ViewMode = "All"] )The following is an example of a Document Library I have just created and "All" the metadata columns that can be obtained from the List using SharePoint.Tables. Is it possible that Column has a different name on background compared to the UI?
4 Replies
Hi AlexJ01 - this is good question. In Power Query, there are 2 connectors
- SharePoint.Files - PowerQuery M | Microsoft Learn
- SharePoint.Tables - PowerQuery M | Microsoft Learn
You will use the first to content to SharePoint to find the Binary files in the [Content] column. When you content to the Site Collection please note that it will contain every document in that Site, so make use you use the FolderPath to select the correct Library and Folder.
Source = SharePoint.Files( #"URL for Site Collection" , [ApiVersion=15])
You can use the second to get SharePoint lists... and a Library is just a List of documents! This list will contain the properties like person, status, but it does not documents. When you use the below, you will be presented with a Table for all the elements in SharePoint, the Library should appear on the one of the rows. Just expand the Table to see the List perpective of the documents.Source = SharePoint.Table( "URL for Site Collection" , [Implementation="2.0"])The two tables can be joined using the Name of the document. Yes - it is annoying the GUID is not available in both result, so be careful with duplicates.
Hello! Thank you for your help. I've treid using the two different connectors as you suggested above, but "Approval Status" still does not show in any columns. I've added a screenshot below of the column I need.
HI - it should appear on the SharePoint.Tables. You might need to change the "VeiwMode" to include all columns:
SharePoint.Table( URL, [Implementation = "2.0", ViewMode = "All"] )The following is an example of a Document Library I have just created and "All" the metadata columns that can be obtained from the List using SharePoint.Tables. Is it possible that Column has a different name on background compared to the UI?
Thank you, that's done it! Much appreciated!
