SharePoint Designer - how to

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?
MSI-LindaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

66866Commented:
I don't think this is possible using SPD, I would recommend using Visual Studio since this is much simpler using code.
0
MSI-LindaAuthor Commented:
I am a SharePoint Architect, I am not a developer.  My customer requires everything be done with SPD so that they can support it afterwards.

From what I have read and tried so far, this should be able to be done using SPD, since I am able to create the ONE record copy, I should logically be able to create 3 more copies pulling the parsed value for the other records.

Are there any SharePoint Designer (SPD) experts please??
0
66866Commented:
You have to understand one thing, SPD is a very powerful tool for creating client side applications (including webparts and workflows). It does not have the ability to read a value and perform the kind of parsing that you have requested. Even to accomplish this, you'll have to create custom Javascript codes on the workflow initiation page so that it can parse the value.
Anyway, I am curious to see what other experts have that can help you out.
0
MSI-LindaAuthor Commented:
Actually I found the solutions myself and I can do this using SPD.  I just had to copy the Multi-value Data Lookup field to a Muti-line text field. Then I created Formula fields that check to see if it "contains" each server name.
Then I had to install this CodePlex addition for SPD workflows here that allows me to copy an Item and overwrite the existing item.  http://spdactivities.codeplex.com/
 
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
66866Commented:
I am glad for you :-)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.