Solved

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

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

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…
I have put this article together as i needed to get all the information that might be available already into one general document that could be referenced once without searching the Internet for the different pieces. I have had a few issues where…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

705 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

19 Experts available now in Live!

Get 1:1 Help Now