I'm trying to run a simple workflow to lookup some values from a table based on a multi value field in a template. I originally wanted to do it as a Dynamic field on a template - but since the field could have anywhere from 1 to 10 values and I need to return all the data this didn't work. (Essentially I want to enter an ID number and return Lastname and Firstname)
When I run my workflow it seems to go into a spiral and won't complete (if there are values in the ID field or not) I branched the workflow so it would only run if the ID field had content - but it still isn't completing the workflow.
Also if someone goes back and adds an extra ID to the field it duplicates the first entries firstname/lastname and then adds the new one to the end. I hope this makes sense, I've attached a screen shot of my workflow - which has gotten more complex than I think it needs to be, but I was trying different things to get it to work.