SOLVED

How to get versioning for whole SP list and not just individual items

%3CLINGO-SUB%20id%3D%22lingo-sub-1767876%22%20slang%3D%22en-US%22%3EHow%20to%20get%20versioning%20for%20whole%20SP%20list%20and%20not%20just%20individual%20items%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1767876%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Community!%3C%2FP%3E%3CP%3EWe%20have%20a%20SP%20list%20and%20it%20has%20around%202000%20row%2F%20items.%3C%2FP%3E%3CP%3EAny%20user%20can%20go%20and%20make%20changes%20to%20any%20of%20the%20fields%2C%20we%20can't%20ignore%20that-%20we%20have%20to%20give%20access%20as%20they%20have%20to%20edit%20the%20values%20on%20continuous%20basis.%3C%2FP%3E%3CP%3EBut%20sometimes-%20if%20someone%20grossly%20edits%20multiple%20rows-%20how%20would%20i%20be%20able%20to%20know%20where%20problem%20occurred%20and%20who%20did%20it.%3C%2FP%3E%3CP%3EI%20can't%20be%20clicking%20on%20version%20history%20for%20each%20of%20the%202000%20items.%3C%2FP%3E%3CP%3EPlease%20suggest%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1767876%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1767957%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20get%20versioning%20for%20whole%20SP%20list%20and%20not%20just%20individual%20items%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1767957%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F696948%22%20target%3D%22_blank%22%3E%40GulianiG%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI'm%20afraid%20this%20is%20not%20possible.%26nbsp%3B%20You%20may%20only%20configure%20versioning%20on%20the%20individual%20list%20items%2C%20not%20the%20overall%20list%20itself.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20want%20visibility%20on%20who%20did%20what%20though%2C%20maybe%20consider%20using%20audit%20log%20search%20in%20the%20Security%20%26amp%3B%20Compliance%20Center%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1767963%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20get%20versioning%20for%20whole%20SP%20list%20and%20not%20just%20individual%20items%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1767963%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F616707%22%20target%3D%22_blank%22%3E%40PeterRising%3C%2FA%3E%26nbsp%3BThanks%2C%20but%20my%20IT%20folks%20are%20not%20giving%20me%20O365%20admin%20access%20for%20audit%20logs%20claiming%20that%20even%20though%20i%20am%20the%20site%20owner%20for%201%20site-%20i%20can't%20be%20allowed%20admin%20access%20privileges%20as%20that%20would%20mean%20i%20can%20see%20data%20for%20SP%20sites%20i%20am%20not%20even%20a%20member%20or%20owner%20of.%26nbsp%3B%3CIMG%20class%3D%22lia-deferred-image%20lia-image-emoji%22%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fhtml%2Fimages%2Femoticons%2Ffacepalm_40x40.gif%22%20alt%3D%22%3Afacepalm%3A%22%20title%3D%22%3Afacepalm%3A%22%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1768617%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20get%20versioning%20for%20whole%20SP%20list%20and%20not%20just%20individual%20items%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1768617%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F696948%22%20target%3D%22_blank%22%3E%40GulianiG%3C%2FA%3E%26nbsp%3BHello%20again!%20%3A)%3C%2Fimg%3E%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20could%20use%20Power%20Automate%20to%20trigger%20on%20changes%20for%20that%20specific%20list.%3CBR%20%2F%3EI%20can%20not%20recall%20how%20well%20it%20performs%20on%20that%20many%20list%20items%2C%20but%20I%20think%20it%20is%20worth%20a%20try.%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20trigger%20could%20send%20an%20approval%20flow%2C%20or%20just%20specify%20the%20change%20(custom%20audit%20log).%26nbsp%3B%3CBR%20%2F%3EThe%20link%20below%20shows%20you%20a%20template%20to%20get%20started%2C%20however%20I%20recommend%20adjusting%20the%20solution%20to%20fit%20your%20request.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Femea.flow.microsoft.com%2Fen-us%2Fgalleries%2Fpublic%2Ftemplates%2F3821506240744debadcd89c94690652d%2Fwhen-an-item-in-a-sharepoint-list-is-modified-send-an-email%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Femea.flow.microsoft.com%2Fen-us%2Fgalleries%2Fpublic%2Ftemplates%2F3821506240744debadcd89c94690652d%2Fwhen-an-item-in-a-sharepoint-list-is-modified-send-an-email%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYours%20sincerely%2C%3CBR%20%2F%3EAref%20Halmstrand%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

Hello Community!

We have a SP list and it has around 2000 row/ items.

Any user can go and make changes to any of the fields, we can't ignore that- we have to give access as they have to edit the values on continuous basis.

But sometimes- if someone grossly edits multiple rows- how would i be able to know where problem occurred and who did it.

I can't be clicking on version history for each of the 2000 items.

Please suggest

4 Replies

@GulianiG 

 

I'm afraid this is not possible.  You may only configure versioning on the individual list items, not the overall list itself.  

 

If you want visibility on who did what though, maybe consider using audit log search in the Security & Compliance Center? 

Highlighted

@PeterRising Thanks, but my IT folks are not giving me O365 admin access for audit logs claiming that even though i am the site owner for 1 site- i can't be allowed admin access privileges as that would mean i can see data for SP sites i am not even a member or owner of. :facepalm:

Highlighted
Best Response confirmed by PeterRising (MVP)
Solution

@GulianiG Hello again! :)

You could use Power Automate to trigger on changes for that specific list.
I can not recall how well it performs on that many list items, but I think it is worth a try.

The trigger could send an approval flow, or just specify the change (custom audit log). 
The link below shows you a template to get started, however I recommend adjusting the solution to fit your request.

https://emea.flow.microsoft.com/en-us/galleries/public/templates/3821506240744debadcd89c94690652d/wh...

 

Yours sincerely,
Aref Halmstrand

Highlighted

@ArefHalmstrandThanks, i gave good grasp on Power Automate & Apps, hopefully will leverage it to suit our business need. This link is helpful :)