Customer is asking to maximize Workflow history limit from 60 days to 1 year.
I have checked through Nintex forums and I got the following
But above link is okay with SharePoint On-prem environment.
I also searched this blog post Recovering Workflow History after 60 days
Q: Which Settings should I change for SharePoint Online for Workflows?
Thanks in advance.
Solved! Go to Solution.
For O365, this is a setting that cannot be adjusted. It is a farm setting in the timer services and it isn't accessible in sharepoint online. As a best practice, it is optimal to use Lists to store important workflow history for long term auditing and not rely on the workflow history lists for many reasons. Read more in super crazy detail in
But I find it more easily laid out by the great Patrick Hosch in the blog How NOT To - Workflow History for Auditing | ProjectPoint
Thanks a ton for your pointers Andrew Glasser I just used basic Workflow History's Information Management Policy Settings as follows:
thanks Andrew Glasser ..
If I configure Audit for Workflow History I have these options
But the Configure audit settings for a site collection - SharePoint is about SharePoint On-Prem options where we are able to set the max days:
which leaves only Option 2 left (List Data) for SharePoint Online.
Q: Is List Data option is considered the best practice to cater Workflow History requirements for me?
No sorry, I don't think it will. The auditing settings will alert you to changes made, but it doesn't retain the history. The Retention Policies will force a retention, no delete, but it will eventually lead to performance issues with the size of the lists growing and associations kept.
Keeping history data in a separate list using the Create Item action will be the best scenario.
Actually it's a little different. Odd I know. But the reason its different is because you can enforce list view thresholds on the user via views on the custom list. The list itself can hold millions of records without issue, but the views must be limited. Such as a view that filters on a date or last 30 days, by initiator, etc.
You can't do that on the workflow history list when the system is querying it for data and adding more data, so it will experience degradation in an way out of your control. "It's not you, it's me" - SharePoint (so to speak).