
Sharepoint designer workflow update current item from lookup list based on current lookup field
1. Create new custom list "Provinces". Rename Title to ProvinceID. Create new field ProvinceName (single line of text)
2. Create new custom list Employees. Rename Title to FullName. Create new field ProvinceID lookup to list Province and return ProvinceID. Create new field ProvinceName (single line of text)
3. Create new workflow (list workflow)
4....