Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have a list that gets updated every month and currently any item in the list that is over 5 days of the current day gets deleted. However, now I wanted to keep a record of the list items that get deleted every month in either an excel or pdf format.

Could someone please suggest a way I can do this? I have used JavaScript to generate a .iqy file which opens in Excel, but that file is connected to the list in SharePoint and it automatically refreshes whenever the file is open.

I need the report in a format that different users can open without the need to change any settings in Excel.

share|improve this question

1 Answer 1

You could sort of game the system. Instead of giving people stock contribute permissions with delete privs, create a custom permission without it. Add an additional metatada column to the list that acts as a delete option. When modified, you replicate any metadata to a separate custom list via workflow then use an impersenation step to actually delete the item.

Then you can run any reports you need to off this archive list.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.