I have a SharePoint list of Contractors (name and multi-select column called tools).
I also have a SharePoint list of Workers (name, lookup column to the contractors list, and multi-select column called tools).
What I would like to do is create a workflow that will look at the Worker list, find all unique contractors, then find unique tools used by the workers assigned to the contractor. In the end, I would like to update the contractor's tools multi-select column with the distinct values in which their workers are assigned.
For example:
Contractor ABC has 3 workers.
Worker A uses the following tools: hammer, saw, compressor, chalk line
Worker B uses the following tools: hammer
Worker C uses the following tools: pliers, compressor
Contractor XYZ has 2 workers.
Worker X uses the following tools: hammer, chalk line
Worker Y uses the following tools: saw, hammer
In the end, I would like to update the multi-select tools column in the Contractor list with distinct values from their workers. So,
Contractor ABC would have the following tools: hammer, saw, compressor, chalk line, pliers
Contractor XYZ would have the following tools: hammer, saw, chalk line
To summarize, the Contractor list will show distinct values of all the tools in which their workers use. Folks will find it easier to look at the contractor list to find a summary of their worker's tools vs searching each and every worker assigned to a contractor and trying to find the unique values.
Any ideas?
