I will try to be as succinct as possible. Basically I have a Nintex form built on one list for Projects. The form has 10 panels with a Resource Column (which is a People Picker) an Hours column (Number) and Roles (Lookup) in each of them. A checkbox on 9 of them with logic that the other panels are hidden until you check it. Basically trying to mimic a repeating table. The form gets filled out I have a workflow to copy to another list.
Depending on the number of resources you fill out is how many items on the next list. So choose 4 resources on List A workflow writes 4 separate rows in list B. The challenge is on List B there are columns for Resources, Hours, Roles and Project Name. So I want to pull that info from List A. So the 4 rows in list B now have four different individual Resources, Hours, Roles and all with the same project name.
I can link the two lists easily enough as List B's Project Name is a lookup to List A's Project Name column which gets populated by the form. I can create multiple rows as well using Run If and Copy to SharePoint controls. I even have a For Each which can then pull all the ID's from List B in a variable. I'm trying to do a For Each but that just populates the Resource field with the last user's name in the Resources column rather than the 4 unique Resources on the form. Can this be done? Thanks so much for reading all of this and answering in advance.
