Share
Report
4Hi.
Need help using connector in sharepoint for "Get File Properties". I want the properties of a file's previous version(s). There are several videos and posts on the web about comparing two excel docs. Most of these are people hard coding two explicit files that then do a "list all rows in table" and compare, build an array, make it look good.
I want to do what I believe ALOT of people want - compare the latest version to the previous version or previously "approved" version in sharepoint. We have our excel files inside sharepoint with version control turned on. I can see, view, and restore them.
I can get the rows in the table from the current version, but I'm stumped as to how I can access and reference previous versions of the files directly with the "Get File Properties" or "Get File content" actions in the sharepoint connector. I've tried to reverse engineer the file paths from the version history restore UI, try to use URIs - find *any* reference material to accessing a specific file version all over the web and spent now 4 days on this to come up empty.
I believe the file previous versions are stored in a folder called _vti_history/(then some multiple of 512 for each major version number)/share documents/.....Excel.xlsx. Its killing me but I can't find any way to access previous previous versions of an excel file stored in sharepoint so compare against the most recent copy. I've tried to get the file properties to copy, move, access, and more. Seems I can only restore using the POST commands of an HTTP request API.
No one seems to have any content on this posted anywhere. Is what I'm after not possible due to system limitations?
All responses (
Answers (
