I have a list of organizations and a list of contacts. The contacts are linked via vlookup to the organizations list. I would like to have all the contacts associated with a specific organization populate back to the organization list. I have not found a way to have a workflow do this directly as the lookup function only grabs the first instance. My workaround is to make the connections in Excel. Using Concatenateifs I can combine all the contacts associated with an organization into one cell. I could just paste the Excel results into the organizations list, but there are several thousand organizations and SP only lets you paste 100 rows at a time. I struck on the idea of having a third list that was all text based so I could use Access to paste in bulk and then use a lookup workflow to connect the contacts to the organizations with the column containing the contact names as multiple lines of text separated by a ; converting to a lookup column of the contact names from the contact list. That way other info about the contacts could be pulled over to the organization list. The problem is I can't seem to build a workflow that will accomplish this.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.