Home

SP list history

%3CLINGO-SUB%20id%3D%22lingo-sub-1232220%22%20slang%3D%22en-US%22%3ESP%20list%20history%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1232220%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3CBR%20%2F%3EI%20need%20to%20have%20SP%20list%20full%20history%20data%20(with%20modify%20columny)%2C%20but%20not%20including%20date%20of%20modifying%20one%20of%26nbsp%3B%20the%20column%20as%20there%20are%20some%20data%20that%20messing%20up%20my%20model.%3CBR%20%2F%3EIs%20there%20any%20intelligent%20way%20to%20do%20that%3F%3CBR%20%2F%3EI'm%20using%20link%20like%20that%20to%20get%20data%20%3CA%20href%3D%22https%3A%2F%2FCOMPANY.sharepoint.com%2Fsites%2FOC%2F_vti_bin%2Fowssvr.dll%3FXMLDATA%3D1%26amp%3BList%3D%7BXXXXXX%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2FCOMPANY.sharepoint.com%2Fsites%2FOC%2F_vti_bin%2Fowssvr.dll%3FXMLDATA%3D1%26amp%3BList%3D%7BXXXXXX%3C%2FA%3E%7D%3CBR%20%2F%3E%26amp%3BView%3D%7BXXXXX%7D%26amp%3BRowLimit%3D0%26amp%3BIncludeVersions%3DTRUE%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20already%20trying%20to%20create%20view%20excluding%20that%20column%20but%20modify%20dates%20stays.%20And%20I've%20also%20try%20to%20exclude%20dates%20which%20are%20the%20same%20as%20in%20this%20columns%20but%20I've%20noticed%20there%20are%20some%20delays%20in%20'modified'%20column%20so%20it%20doesn't%20work%20how%20I%20would%20need%20it%20to..%3C%2FP%3E%3CP%3EThanks%20in%20advace!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1232220%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1232428%22%20slang%3D%22en-US%22%3ERe%3A%20SP%20list%20history%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1232428%22%20slang%3D%22en-US%22%3EYou%20could%20write%20a%20PowerShell%20script%20to%20get%20that%20information%20in%20a%20CSV%20file%20that%20you%20can%20after%20that%20analyze%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello,
I need to have SP list full history data (with modify columny), but not including date of modifying one of  the column as there are some data that messing up my model.
Is there any intelligent way to do that?
I'm using link like that to get data https://COMPANY.sharepoint.com/sites/OC/_vti_bin/owssvr.dll?XMLDATA=1&List={XXXXXX}
&View={XXXXX}&RowLimit=0&IncludeVersions=TRUE

 

I was already trying to create view excluding that column but modify dates stays. And I've also try to exclude dates which are the same as in this columns but I've noticed there are some delays in 'modified' column so it doesn't work how I would need it to..

Thanks in advace!

1 Reply
Highlighted
You could write a PowerShell script to get that information in a CSV file that you can after that analyze