TOPIC
INSTRUCTIONS
The Lookup column needs to be populated by inputting the item ID of the item on the list that is being looked up and not its value.
- Add the action 'Office 365 Create List Item or Document Set' onto a pearl in Nintex workflow Designer
- Double-click the action to configure it.
- Specify all mandatory fields as per the help file instruction. See Related Links below.
- From the 'Fields' section, choose 'Builder' and then 'Add Field'.
- Configure the 'Field' field with the name of the lookup column that needs populating.
- Choose 'Lookup' from the 'Type' drop-down menu.
- In the 'Value' field specify the values with the ID's from the list that is being looked up separated by semicolons. For example: 1;3;6;14
ADDITIONAL INFORMATION
Obtaining the Item ID's from the list that is being looked up can be achieved in many ways.
For a simple item creation:
- Navigate to the List Settings of the lookup list.
- Scroll to the Views section and click a View to edit.
- In the 'Columns' sections find the column named 'ID' and tick its checkbox.
- Click Ok.
The ID for each item is now visible and can be used in creating the semicolon delimited input for the Value field in the 'Office 365 Create List Item or Document Set' action.
The default view on a SharePoint list for Office 365 does not show the Item ID.
The above is ok for simple updates but for full automation the Lookup list will need to be queried using the Query List action using a value to find its ID. Once this is done a Build String action can be used to combine the Item ID's to create the string to be used in the 'Office 365 Create List Item or Document Set' action.
