AnsweredAssumed Answered

How Do I loop on a Grouped Value

Question asked by davidjohnson5000 on Oct 28, 2016
Latest reply on Nov 10, 2016 by davidjohnson5000

I have a document library that has a field called Manager.  There are over 30 managers.  I want to send 30 emails to each of the 30 managers along with all there associated rows.  I set up a WF that uses a Run Query first that retrieves the entire library for today's work.

 

Within the Query I have a Managers Collection,Log Description Collection and a Call Center Collection.

 

  1. I then do a For Each on the Managers Collection.
  2. I have a Get Collection Operation for Manager, Log Description Collection and Call Center Collection
  3. Outside of the For Each I have a Send Notification.
  4. Instead of getting 30 emails I get 1 email that displays all the log calls for all 30 managers.

 

I know I can set-up 30 Workflows and query for each manager, but there has to be a more efficient route.  Essentially I want to retrieve all data found for Manager 1 and send email, the next iteration would look for all data associated with Manager 2 and send email, etc...Perhaps I need to use a Loop in combination with a For Each

Outcomes