Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Is it possible, using SharePoint Designer 2010 (SharePoint 2010 Enterprise Edition) to copy multiple list items from list A (Personnel Clearances) to a single field (of any type) in List B (DD254) where Contract Number in list A is equal to Contract Number in list B? I need to copy the personnel who are on this contract to a field in each contract list item at time of creation. The values need to be in the list so that I can reference them in email notifications that are being sent out in another workflow on the DD254 list. I have tried using two separate workflows to loop through the list items but no matter what I do, it only copies in the first matching value. I am using an InfoPath form for new item creation in the DD254 list so I also tried to set the "personnel" field in the form to the Employee Name field from the Personnel list where contract number = contract number. With this scenario, I get script errors because I am trying to query a list of 5,555 items in the form (the system limit on list items is set to 10,000) I do not have Visual Studio. I have SPD only and it seems to me that this should be possible. I don't actually have to copy those values into the list item. I just have to be able to reference that filtered set of data in a workflow email. The data in both lists will change regularly. I will have to import a new set for each list monthly. Here is the current state of my workflow. I have removed stops and pauses for testing purposes. This workflow copies in the first value and then completes with no errors: Copy Personnel Counter Workflow (Starts when items are created and changed, attached to the DD254 List): Step 1: Set Variable currentCount to Current Item:Count Calculate currentCount plus 1 Output to Variable newCount Update item in Personnel Clearances (Count = newCount, Processed = In-Progress)(Field: Contract Number/Value: CurrentItem:Contract Number) Update item in Current Item: Processed = Processing

Copy Personnel Worker Workflow (Starts when items are edited, attached to the DD254 List) Step 1: Wait for Current Item:Processed to equal Processing Step 2: Set Variable valPersonnel to Personnel Clearances:Employee Name )(Field: Contract Number/Value: CurrentItem:Contract Number) Set Current Item:Personnel to valPersonnel (as string) Update item in Personnel Clearances:Processed = Yes )(Field: ID/Value: CurrentItem:ID) (When I use Field: Contract Number/Value: CurrentItem:Contract Number here, the workflow errors on this line but it works with ID, except it returns only one value) Any advice is greatly appreciated! Thanks, Sara

share|improve this question
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.