cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
davidjohnson500
Nintex Newbie

Update another List - Source value has multiple ID's

Jump to solution

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

Labels: (1)
0 Kudos
Reply
5 Replies
Automation Master
Automation Master

Re: Update another List - Source value has multiple ID's

Jump to solution

Hi

OK my list A is called "Busch" and looks like this:

luColours column is a lookup column allowing multiples from my list "Colours" choosing the ID as the value to store.

In my workflow on the Busch list I have the following:

First action regular expression - I pass in luColours column and look for ";" and choose to split and store the result in a collection variable called vCollSelection

Then I use for each to loop through the collection, storing each item in the collection in an ID variable called vID

Inside the loop, so for each ID in the collection, I update the colours list where ID in colours list = vID and update the column List A UID with the current item (in Busch list) ID

Reply
Automation Master
Automation Master

Re: Update another List - Source value has multiple ID's

Jump to solution

I assume you will want to add to the column, rather than overwrite it.  so you may need an additional step.  inside the for each, query list b where ID = vID and pull in the information from column List A UID into a text variable.  Use a build string action to make the text variable equal to it's previous value plus the new ID from list A.  And then update your List B column with the text variable.

Reply
Automation Master
Automation Master

Re: Update another List - Source value has multiple ID's

Jump to solution

What is the purpose of this requirement?

0 Kudos
Reply
davidjohnson500
Nintex Newbie

Re: Update another List - Source value has multiple ID's

Jump to solution

For List A it represents new claims.  New claims will typically have an associated email.  Thus in List A I have created a lookup to List B to select the associated email(s).  Note multiple emails can be associated with 1 claim. 

Currently for List B (the emails) we rely on the user to manually select each record and select the associated claim (via a lookup field).  Each email record can only be associated with 1 claim.  The issue is the users are howling that they manually need to go to List B and select the associated claim id.  The requirement is once the new claim is created to back-fill List B (email records) with the Claim ID for all associated emails found in List B.

0 Kudos
Reply
davidjohnson500
Nintex Newbie

Re: Update another List - Source value has multiple ID's

Jump to solution

This worked !

Reply