I have List A and it has a Multiple Value Data Lookup field to List B.
I have a SharePoint Designer Workflow that is attached to List A, and upon Creation it Create New Item in a new List C. The purpose of List C is just to be a smaller most recent copies of List A.
However, when there is more than one item in the Data Lookup field (Item1;Item2;Item3;Item4) then I need it to create a new item in List C for "each of those data lookup values. So I need it to create 4 new records in List C for the last example.
I created a new Multi-line text field and in the Workflow have the Data Lookup field copied to it assuming that I will next need to somehow parse and copy each line of data prior to the " ; " that separates them.
Anyone know how I can do that with SharePoint Designer?