Sharepoint Version History Output

(0) Share

Report

Posted on by craig_01

153

I have a SharePoint list that tracks some core process statuses via 5 key "choice" columns.

For example:

Col 1 - (No/Pending / Complete)

Col 2 - (No / Pending / Complete)

etc......

From an analytics point of view, i would like this version history to update into a Excel list, creating like a running log.. So i can see timeframe between changes on a particular line. A timestamp of when Col1 was set as NO, and then when it was subsequently set at Complete..

And if so, how would i go about attempting this output.

@abm

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

Nived_Nambiar 18,136 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @craig_01

How should the output report should look like ?

could you share a template /screenshot of it ?

Was this reply helpful? Yes No
abm abm 32,975 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @craig_01

Created a video based on this. Please have a look.

https://youtu.be/5O50FZEGU48

Thanks

Was this reply helpful? Yes No
craig_01 153 on at

Like (1)

Report
Copy link

Link copied!

Hi @abm , thanks for the video, is there the ability to have the output to an excel automatically each time a change is made>?

Regards
Craig

Was this reply helpful? Yes No
Verified answer

abm abm 32,975 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @craig_01

Yes you can. So the trigger should be when an item is modified. The find the current version minus 512 will give you the previous version number. Rest I mentioned in the video. Finally once you got the values insert into a Table. So to do this first create an Excel sheet with table under SharePoint or Onedrive.

Thanks

Was this reply helpful? Yes No
craig_01 153 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your assistance

Was this reply helpful? Yes No