Forum Discussion
Getting SharePoint List items with full history version?
Hi, We do have a SharePoint list to manage Fleet inventory of asset: mainly their attribution (who own it) and their status (active, lost, broken, etc.). We did activated the SharePoint Version ...
This one worked for me:
https://sharepoint.stackexchange.com/questions/190021/exporting-item-list-version-history
:manhappy:
Short explaination:
The "&IncludeVersions=TRUE" gives all changes form all versions (form all fields)
Make a Sharepoint List which only contains the columns you need. (or split it up in several views and repeat this trick)
Open the XML in Excel en there you can create a PivotTable and if you include the version field in SharePoint view.
You can see the version number in the Pivot :smileyvery-happy: Just sort on this version number and you will see the latest and all previous versions.
There appears to be a 30 column limit on the &IncludeVersions=TRUE approach