Bulk Upload - Look up value and if match - Update columns

  • 31 March 2020
  • 1 reply
  • 0 views

Badge

Hi All, Fairly new to Nintex Workflow and looking for some assistance.

I have 2 lists - I want to Paste bulk data into List A which will look for a matching value in List B and then update the remaining columns.

 

I have managed to get the workflow to look up the value and match it, however when updating the additional columns it repeats the first match:

I.E - List A is my bulk paste

List B is the result

List A  
Refernce Number Date Receieved
555 1/01/2000
666 2/01/2000
777 3/01/2000
888 4/01/2000
   
List B  
Refernce number Date Received
555 1/01/2000
666 1/01/2000
777 1/01/2000
888 1/01/2000

 

Any assistance in how to store the individual dates and match them accordingly would be apprecaited.


Cheers,


1 reply

Badge +16

can you use a workflow to update column in list a?  when you configure update item use the list lookup option to list B where the IDs match?

Reply