[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1536
  • Last Modified:

How to split the SharePoint Document Library Column using SharePoint Designer Workflow

I am trying to split a string which is stored in a SharePoint2013 document library and I want to loop through this and put the document in to separate library based on the split value.


List A(Document Library) - has the column called Candidates which has the values like (101,102,103) with some document attached to the list. Now I want to split that Candidate column and insert each value in to different library with the corresponding document.
Maheshkumar K
Maheshkumar K
  • 2
  • 2
1 Solution
Download it to Excel, process it there, then create a new list from your Excel document.
Here is an example using Office 365 http://blog.blksthl.com/2014/01/15/office-365-guide-series-create-a-new-list-from-an-excel-spreadsheet/
Maheshkumar KAuthor Commented:
Hi Colly,

I am not sure about the solution what you have given. Let me brief the problem again.

I have  2 document library, 1 Document Library has the pdf file uploaded with few metadata for eg.

Document Name      BUID                      Cust Name
document1      101,102,103,104      abz

I want the above item inserted into another library like below:

Document Name      BUID      Cust Name
document1.pdf      101      abz
document1.pdf      102      abz
document1.pdf      103      abz
document1.pdf      104      abz

All these need to be done using SPD 2013 Workflow.
Have a look here and learn how to build a workflow, its not hard but there is a lot to do:

If you want this to happen automatically when a document is added to library 1, then you could also use an event receiver rather than a workflow.  If you know c#/visual studio then this is actually probably easier to do than building a workflow.  Here is a simple example to get you started: http://onceinawhilescribble.blogspot.co.uk/2013/05/creating-simple-event-receiver-in.html
Maheshkumar KAuthor Commented:
Thanks Colly. I have implemented this using the Event Listener. But I am interested to achieve this using SPD Workflow

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now