I am working on an Estimate Intake Form for our company. When someone has a request for new work and needs estimates, they will submit the form and tasks are assigned to the necessary parties to complete the estimate.
I have multiple SharePoint lists (think of them as tables) that help with ease of maintenance for less experienced site owners (they can add/remove rows in a list rather than modifying columns in the list settings). Here are the lists and relevant fields for this question:
People List:
Department List:
Estimate Intake List (Main List for Form):
Summary of what I'm going for:
If a person in the People List has a Department that matches what was selected in the form under "Impacted Department", add them to the Assign Task.
In detail, what I'd like the workflow to do:
Problem:
I'm really struggling to figure out how to make this happen. I've tried For Each loops with collection variables, but I don't know how to loop through a complex collection (step 2 above) and read the values for Department. In all honesty, I'm completely lost so any assistance would be greatly appreciated.
Thanks in advance for the help!