I have a Library called Intake with a property field called Assignee. The column called Assignee allows multiple values. I want to loop thru the library and copy an individual item from the Intake library to another document library called "Owners" (within the same site) for each value found in the Assignee column.
Thus if the Intake Library has 1 item and the Assignee field contains 2 values: Tom and Jerry. Then I want to copy the same item twice from the Intake library to the Owners library. I do realize in the Owners library that the Name will display a time stamp since the same file is being loaded multiple times. In addition I will do a Set Value so the Owners item has the individual assignee's name.
Essentially my question is using my example how can I determine that I need to copy the item twice into the Owners library. I am somewhat familiar with Query List, For Each, and Collections which I assume I need to use, but determining how to iterate on each value found for the Assignee field has me stumped ?