Ok, so I hope I can explain this well. I am trying to create a Business Process, that allows the user to:
Fill in a form, that has a variable number of rows with the following columns.
- Name
- Position title
- email
So lets say submission1 = 2 people
submission2 may have 6 people, and so on.
My process with take that start form and trigger a Workflow Service Task.
The goal of my workflow is to :
- Retrieve the variables ( this works )
-- For each contact submitted ( much like a mail merge )
- Update a Word Doc per contact submitted. ( it only merges the first contact, and repeats that )
i.e 2 contacts.. 2 documents
6 contacts submitted, 6 word docs generated
-- then I email ALL the documents as an attachment to 1 user ( this works )
The problem I am having in the workflow is, looping through the variables and trying to get them out into the Update word activity.
I have the Find/Replace fields working correctly. If I submit 1 contact through it works perfect.
How can I have it handle more than 1 correctly ? I tried For Each Value activity.. but I feel like it wont carry through multiple variables. i.e name, title, email., and still keep track of which row