I'm struggling with site workflows in Nintex Workflow Cloud and need some help. I have a document library and a custom list serving as a task list. The document library has a workflow that creates items in the task list and sends emails to Reviewers to complete their task. A document may have multiple reviewers and all reviewers must complete their tasks. I would like to run a site workflow every day to find tasks that were updated in the last 24 hours. Then compare the Approval Status to the other tasks in the list to see if all tasks have been completed for the related document which is listed in a lookup column in the task list.
As an example,
Document library has a document called ABC Contract.pdf and 2 people need to review it. Task list example shown in attachment.
My end goal is to query the task list and check the Approval Status column and if the approval status on all related tasks have the same status (and not Pending), then update the Approval Status column in the Document Library to that value. I can’t seem to figure out how to get the Approval Status for each of the related items to see if they all match.
The workflow queries the Task list to find all the records updated in the last 24 hours before looping through to find all the records where the lookup column document ID matches and add to a new collection. After getting all the records where the lookup column document ID matches, I get stuck trying to find the Approval Status for each. I have an inner Loop to loop through the collection of matching doc IDs and the only thing that I can get seem to be use is the entire object. I have attached a screenshot of the Loop for Each section of my workflow.
Why can only enumerate the objects in the inner loop? Am I going about it the wrong way?
Best answer by Prineel_V3View original