Forum Discussion
Version History with Check in Comments
I'm trying to connect to documents within a sharepoint library and pull back the version history including the check in comments. For some reason I can get all of the comments for previous versions, but not the current/latest version.
For example I have File A - the current version is 1.5 with checkincomment Approved by Final Approver, but when I pull back the data in Power Query I see every version except the latest one
| Name | Version | Modified | Checkincomment |
| File A | 1.1 | 12:01 | Draft file created |
| File A | 1.2 | 12:03 | First approval requested |
| File A | 1.3 | 12:10 | Approved by 1st approver |
| File A | 1.4 | 12:37 | Approved by 2nd approver |
Is there a way to pull the latest version through and merge the two queries?
Hi DM85,
Just to double check. What methods/Uri are you using in your API calls. Can you share your REST API call?
I have seen different results when people tried using the items method instead of directly interacting with the file versions. Below is an example of a similar discussion:
4 Replies
Might not even need an API call for that. See if you can change the view.
How to display the last check-in comment in a document library | SharePoint Maven
Hi DM85,
Just to double check. What methods/Uri are you using in your API calls. Can you share your REST API call?
I have seen different results when people tried using the items method instead of directly interacting with the file versions. Below is an example of a similar discussion:
Expiscornovus thank you - this worked
