create list item compare to other list

  • 17 May 2019
  • 1 reply
  • 10 views

Badge +4

I have two lists

1. MasterList

2. ChildList

 

Requirement: Whenever item created in MasterList --> a new item should be created in ChildList (Condition =if the item doesnot exist in the ChildList. )


Whenever item is updated in MasterList --> Child list item should be updated.


1 reply

Userlevel 6
Badge +22

Hi,


 


"Requirement: Whenever item created in MasterList --> a new item should be created in ChildList (Condition =if the item doesnot exist in the ChildList. )"


Does that mean that you might have duplicates in the Main list?


The workflow would have to start on Item creation.


There should be something unique about each item


The workflow would then look at the child list for that unique attribute and if exists update the main item with the item ID of the child. If not there create the item and record the item ID and update the main list item with the item ID of the child item.


 


When an item is updated in the Main list a workflow configured to start on item modification is started and compares the main item to the child.  The workflow knows which is the child as it looks it up using the item ID on the main that was updated when the child was created.

Reply