AnsweredAssumed Answered

Update another List - Source value has multiple ID's

Question asked by davidjohnson5000 on Dec 20, 2017
Latest reply on Dec 21, 2017 by davidjohnson5000

I have 2 Lists.  List A has a look-up field where multiple values can be selected.  I store the ID.  Thus the record may look like the below:


List A

ID   Title       Color   Lookup Designer:ID

1   My Idea   Blue             55;59



When a new record is created in List A I would then like to update List B with the List A ID.  I know a split can be done to extract the 55 and 59, but how do I essentially do a split and loop thru the split values found in the new record from List A and update List B with the List A ID ?


List B

ID      List A UID

55       1

59        1