I want to create a weekly report that looks at the frequency of the distinct items in the "Created By" column on an incoming email library. Is there a way I could automate this, such as a workflow?

So far I have tried creating a view that shows me only the current weeks items and put a sorted by "Created by" and count on "created by". The problem is I have to export this view to excel every week and at the same time every week or the data could be off.


You can use PowerShell cmdlets to filter and export the items into Excel. Then create a Scheduled windows task to run the cmdlets weekly.
Export SharePoint List Items to CSV using PowerShell
Creating a Scheduled Task in Windows 10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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