Solved

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

Posted on 2014-09-15
2
991 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
[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
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: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying 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

Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
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…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

733 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