(I don't even know if this is possible) I need to create a new item in the list, but the trick is I have three lists: List1 - Dates, List2 - items, List3 - PlantsNumbers. So the desired scenario is: when a new item is created in List1 -> New items should be created in the List2 and there should be as many items as I have in List3. Example: I have 5 plants in the List3: A001, A002, A003, A004, A005. When I create a new item in List1, I need a workflow to create 5 new items in List2 with A001 -A005 as title. Lists 2 and 3 are connected by look up column - plant Number. We have SP 2013.
Create additional columns in List1 nd List2 lets say - list1ID and list2ID.
Create a workflow in List1 with Start Option - Item is created (WF1)
- Create varID and set varID = 1 (or any whichever is your first item in List3)
- Steps -> Create item in List2, with fields - Title (from List3 for ID=varID) and list2ID = varID and remaining fields as required.
Create a workflow in List2 with Start Option - Item is created (WF2)
- Steps -> Calculate list2ID +1 and save to calc variable Update Item in List1 : field is list1ID to value calc
Create a workflow in List1 with Start Option - Item is changed (WF3)
- Steps -> If(List3(Title) for ID=list1ID) is not empty Create item in List2, Title is List3 Title where ID = list1ID, other fields as required and list2ID = list1ID
So, when a new item is created in List1, WF1 will create the first item in List2.
WF2 will update the item in List1.
WF3 will create the next item in List2.
This process continues untill there is no item left in List3