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
Solved

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

Posted on 2014-09-15
2
967 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Experts-Exchange users below are the steps you can follow to upgrade your Lync server to latest CU's or cumulative updates. Note: Perform it during non-production hours.   Step 1: Backup your lync and SQL server database. Follow below article: h…
The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

856 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