Workflow for Nintex for o365 for a 3rd list based on other two lists.

I am having 3 lists A,B,C with 3 forms A form, B form and the C form and now i am looking up some columns from A and B lists to C list and then created 100 items.

Now i am updating the columns in A and B and again creating the new items In C and so new items will be having the updated column values only.

But How to run a workflow on C for the existing and already created items in C ? is it possible to run a workflow every time whenever something gets changed in lists A and B.

I am using Nintex for o365.

Page 1 / 1

So, every time you create an item in List A or List B, you want to duplicate that item into List C? As well as every time something is updated in A or B, you want it to update the appropriate item in C? What is the purpose of list C? Is it combining things from A and B? If an item, say item 1 exists in List A, will it always have a counterpart in List B? If it does not, what does List C do?

It is possible to have a workflow run on List A and List B on modification and on item creation that can update or create items in List C, but I need to understand more about your use case to help further.

Courtney Vargo

Thanks for the reply. Its not getting duplicated.For suppose list A and B had 10 columns each and now the list C is using these 20 columns as a lookup in the third form and say 100 items are created. Now the 10 columns in list A and B are updated with different values and saved and again new items are created in List C again.

My question is how to update the existing or already created items in List C with updated values in List A and B.If it's a workflow to be written in List A and List B, please let me know how the workflow gets triggered for the existing items ?

Are these lookup columns or lookup controls on the actual form? Or something else?

Thanks for the reply..Courtney....

I had given the screenshots for the lists for clear explanation of the issue.

In Division name list Company name is the field which is getting looked up in Company name list.
In Account list Division name and mailing address are being looked up from Division name list and Company name and account no from the company list.
If you look in Account list there are already 2 items.
If suppose i edit the value of "Division name" in Division name list and create a new item in account list item will be created with the updated new value.
So now how do we write a workflow for the existing 2 items in the account list to be updated with the new value of division name.
Imagine if i am having many items i cannot manually edit and save the item to get updated.

Hope you are getting my question..

Company list