Update 1-3 Records on List B based on Status field in List A

I am attempting to use a Nintex workflow to update the status field in List B based on the status of a field in List A. The common link between the two lists is Unique ID (List A) and PAS ID (List B).

List B can have 1-3 records with the same ID as List A, and I only want to select those 1-3 records and change the status, plus one other field.

After reviewing several different solutions, I tried using Query List (setting Collection Variables), For Each Loops, and Update Multiple Items; however, the result is that it is updating all items on the list rather than updating just the match on the IDs between the two lists.

I see several posts with similar questions, but I am not able to locate the exact solution for this particular question.

Any suggestions would be most appreciative.

I am using SharePoint 2010 with Nintex Workflow version Version: 2.4.9.0.

Attachments

I took a look at your workflow but unfortunately I can only see the actions and not the configurations since I don't have the same lists / libraries.

What does the condition do?

For me, I would have the workflow conditionally start on modification -- 'if status changes' (if status X is no longer equal to previous status) -- and then jump right into your Query of List B, get your coll, and cycle through it just as you are.