I have two lists.
- Company Pool Car Request - SharePoint Online list & Nintex form
- DriverRecord - SharePoint Online list
The first list contains 3 columns:
Requestor
Approver
Driving Record Clear - currently set up as a list lookup in the Nintex form for the second list
In the first list, the Requestor is auto populated: [Context].[Current user display name].
The Approver is the Requestor's manager:
userProfileLookup([Context].[Current user email],"Manager".
I'd like to query the second list and save the data from the second list to the Driving Record Clear column.
The second list contains 2 columns. This list is managed by the Admin Assistant. Her job is to enter employee information and check to make sure their driving record is clear.
EmployeeName
RecordClear
When the Nintex form is launched, I would like the Requestor column to check to see if RecordClear is set to Yes or No in the second list and save the value in the Driving Record Clear for the first list.
I am not sure the best way to accomplish this.
