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.
- I then do a For Each on the Managers Collection.
- I have a Get Collection Operation for Manager, Log Description Collection and Call Center Collection
- Outside of the For Each I have a Send Notification.
- 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