I have a SharePoint List, Swimlanes, that has 3 columns: Title, Person, Product Group.
Example:
Title | Person | Product Group |
---|---|---|
Title A | Person A | Product Group 1 |
Title A | Person B | Product Group 2 |
Title B | Person C | Product Group 1 |
I have a Nintex Form that has 5 different list lookup fields, all which connect to the Swimlanes List. Each Lookup field is filtered on the Title column in the swimlanes list. For each lookup field, the user needs to select a user or users (person column) that should be added. Multiple values can be selected.
I would like to set a default value for each List lookup field based on Product Group. For example, if I am filling out a form and select Product Group 1 for the product group field, for Lookup field A (Title A), I would want the corresponding user in the list that matches Title A and Product Group 1 to be the default value. In this example, the default value would be Person A.
Any ideas how I would do that?