Solved

Cannot transfer/copy multiple line of text column to another column in SharePoint 2013

Posted on 2014-09-15
2
867 Views
Last Modified: 2014-09-18
Hi All

Im quite new to SharePoint and Workflows and have run into difficulty with a task that I have been set and was wondering if someone could help me.

I have a list in SharePoint 2013 in which there is a column called Daily_Log_Updates of type multiple line of Text. I want to copy the latest value of this column into another column of type multiple line of text in which the Append Changes is Yes. This column is called Daily Log.

I have managed to create a workflow that is currently carrying out this task for me, however it appends the contents of the Daily_Log_Updates even if other columns are updated in the list creating multiple entries of the same lines of text in the Daily Log

My issue is that I want the workflow to only update the Daily Log  when the Daily_Log_Updates column is amended/updated and not when other columns in the list are updated.

is this possible to d?

Please see my current workflow attached below.

Any help that someone could provide me would be very much greatly appreciated.

Thanks
Tim
sharepointworkflow.docx
0
Comment
Question by:tjoconnor
2 Comments
 
LVL 9

Accepted Solution

by:
macarrillo1 earned 500 total points
ID: 40323455
If I understand what you are asking for; Try the following:

You will need to create another column to track the changes to Daily_Log_Updates.
Lets say DLU_Previous; same datatype.

Then Workflow will do the following on Change:

If Daily_Log_Updates <> DLU_Previous then
Set Daily Log to Daily_Log_Updates
Set DLU_Previous to Daily_Log_Updates.

This way the Daily Log only gets updated when there is a difference between the two version of the Daily_Log_Updates|DLU_Previous.  When the Daily Log is updated then the two version of Daily_Log_Updates|DLU_Previous are synced.
0
 

Author Comment

by:tjoconnor
ID: 40329917
Hi Macarrillo1

Thanks for this suggestion. It worked awesomely

TJ
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

If you create your solutions on SharePoint sooner or later you will come upon a request to set  permissions of the item depending on some of the item's meta-data - the author, people assigned as approvers, divisions, categories etc. The most natu…
This is a fairly complicated script that will install the required prerequisites to install SCCM 2012 R2 on a server.  It was designed under the functional model in order to compartmentalize each step required, reducing the overall complexity.  The …
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

914 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now