Solved

SharePoint Designer - how to

Posted on 2009-05-12
6
359 Views
Last Modified: 2012-05-06
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?
0
Comment
Question by:MSI-Linda
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 21

Expert Comment

by:66866
ID: 24375503
I don't think this is possible using SPD, I would recommend using Visual Studio since this is much simpler using code.
0
 

Author Comment

by:MSI-Linda
ID: 24376247
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
 
LVL 21

Expert Comment

by:66866
ID: 24376929
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
 

Accepted Solution

by:
MSI-Linda earned 0 total points
ID: 24380457
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
 
LVL 21

Expert Comment

by:66866
ID: 24384571
I am glad for you :-)
0

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
I recently came across an issue with a MOSS 2007 deployment where access into some sub-sites were denied, even for the MOSS farm administrators. A bit of background to the setup of this MOSS farm; this was a three server setup, consisting of a fr…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question