I have created a approval workflow using SharePoint Designer workflow. I want to query the task list to get the task with minimum due date for the current task approver.
Below is the scenario :
I have created a list named list2 with two columns Approver(person or group) and minimal due date(date time). Approver column is designed to store unique values. The minimal due date column should always store the minimum due date from the task list for the approver.
What I have done till now is assign due date in "Minimal due date" column when a task is created after the the two dates.
Where I am stuck is how to handle "Minimal due date" column when the task approved, rejected cancelled or deleted.
My idea was to get minimum due date from the task list where assigned to the specific user and status is not started, but I am not able to find any action to support this.
Could someone please suggest if this approach is feasible or suggest some other approach to achieve the task.