AnsweredAssumed Answered

How do I create a workflow to copy some fields of two related lists into a third when those items are modified or created?

Question asked by askinner on Nov 26, 2017
Latest reply on Nov 28, 2017 by krishnachaluvadi

I have two related SharePoint lists; List A uses a SharePoint assigned ID number that becomes the Case ID number for the related List B. I would like to create a third list, List C, that is automatically updated with new or changed information from some of the fields of Lists A and B.

For instance, List A contains the ID, Name, Badge number, date of start and date of processing.  List B contains the ID using a LookUp, date of meeting, date of letter, date of reply.  List C would contain date of start, date of processing, date of meeting, date of letter and date of reply, combined from both lists into one item.  The Workflow would then add new items or modify previous items based on work done in List A or List B.

Thank you in advance for your assistance.