Can't find document Approval Status

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?

AlexJ01