Approval workflow with consolidated multiple rows

scott_hall39226

I am looking for assistance with a workflow that gathers approvals using multiple rows as the source.  The challenge is that I'd like the approver to only receive a single email with all their required approvals. The data looks like this:

Supervisor   Employee   Item        Approve/Reject

Debbie         Kathy         Pancakes    

Debbie         Kathy         Eggs    

Debbie         Scott          Pancakes    

Ruben          Jason        Pancakes    

Ruben          Jason        Eggs    

Ruben          Jason        Bacon    

Barbara        Christoph  Pancakes    

Barbara        Christoph  Eggs    

Barbara        Christoph  Bacon    

Barbara        Stilla         Pancakes    

Barbara        Stilla         Eggs    

Barbara        Thomas    Bacon    

 

Ideally, Supervisor Barbara would receive a single email that allowed her to approve each line item for all her employees.  Less ideal would be a single email for each employee, and not at ideal would be a single email for each employee/item combination.  A supervisor may have dozens of employees with dozens of items, so the combinations lists get quite lengthy. A single email per combination would be worse than manual.

 

Any suggestions would be much appreciated.

 -scott-

Andrée Starå

Hi Scott,

Would it work with an Update Request workflow where she then would approve and go thru each row page by page?

Another option could be to use a third party solution like DocuSign and then the supervisor only needs to approve that one document that could come from a report.

Would that work?

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant / Get Done