I have a sequential approval workflow in which it goes through 3 major groups that we can call Group 1, Group 2 and Group 3. Group 1 submits a list item which needs to be approved by Group 2 and then approved by Group 3 in that order.
I want to find out which user in each group approved what task in the workflow. I originally thought that if I pulled this information from the workflow history list, it would be fairly easy as all I have to do is filter the results by List ID, workflow instance ID, and event type. However, I cannot do this as SharePoint hides the workflow history list and prevents my Nintex custom workflow from accessing it.
I have tried to make the list visible but as soon as the workflow is initiated, SharePoint autohides the list again, causing my Query List action to fail.
Is there any other way to get the information I need with Nintex workflows?