We have an infopath form that is used to submit data to a sharepoint list. This form allows a user to enter multiple selections using a people picker and also multiple selections using a repeating table for offices. We want the user to only have to fill out one form but have that one form create multiple rows in the sharepoint list. We would need one row for each user in each office. So, as an example, if a person filled out the form one time and it had 3 users and 3 offices, this would create 9 entries as follows: ID #1 - User A / Office A ID #2 - User A / Office B ID #3 - User A / Office C ID #4 - User B / Office A ID #5 - User B / Office B ID #6 - User B / Office C ID #7 - User C / Office A ID #8 - User C / Office B ID #9 - User C / Office C
I cannot figure out how to build a workflow that would automatically kick off each time a form is submitted to do this. Please help.