If Name does not appear in drop down close window and start loop

[VeeLearnMSFT]

Stuck again.  My previous problem was how do I start the loop over when an "IF Image" matches---- to which my answer was Next Loop. Now I have a different problem. In step 17, there are scenarios where the person doesn't exist in the drop down.  In that case I want to close the window, press the X, and then start the loop again.  Here is what I did in this step in the error handling I created a sub flow to close the

I started off with creating a sub flow to close the window and then tag a label in front of the loop.  This causes a problem where it keeps on looping over it self and never goes to the next line in the excel spreadsheet.  My next move was to put it in front of the Next loop action in  front 32 but this wont allow it because I think its inside of an if statement.  So then I created a Next Loop after step 33 but then that messed up the scenraio for when a person does exist in the drop down and wanting the flow to continue with the next series of steps.  I guess I am not sure how to throw an error when no person exists in the drop down, close it and start the loop over. 

Step 17 Error Handling.

Drop Down: Step 17 Drop down field

Loop Process.

[MichaelAnnis · Accepted solution]

On error, go to subflow then continue next action.

in the subflow, Set %Skip% to 1

Back in your main flow after the drop down action, put:

If %Skip% = 1

    next

End (If)

at the beginning of your Loop, put:

Set variable %Skip% to 0

this way it will only go to Next if %Skip% is 1 and the loop resets it to 0 before each pass. 

[VeeLearnMSFT]

Michael, you are amazing! Thank you for letting me learn so much.  I still have a lot to learn but little by little hopefully I get in much better shape soon!