Hi,
I have a list with field Name, Location & Vendor - Call it list A
I have another list with all the Vendors information with field Location & Vendor Name - Call it list B
I want to build a workflow when user create new item --> fill up Name and Location --> workflow started --> AUTOMATIC PICK UP THE VENDOR NAME BASED ON THE VENDOR'S LOCATION FROM LIST B AND ASSIGNED IT TO THE FIELD VENDOR IN LIST A.
example:
List A
Name: ProjectA
Location: LocationA
Vendor: Disabled for edit
List B
| Location | Vendor Name |
| A | John |
| A | Angel |
| A | Cat |
| B | John |
| B | Bowie |
workflow
when user fill up Name and location, go to list B, sort location based on the input by user in this case is A and return the vendors available which are John, Angel and Cat. From these 3, select one of them randomly/by sequence. Once obtain the value, assign it to the list A Vendor field.
