PVA Flow - if value is not found return not found.

[VeeLearnMSFT]

Currently my flow works well when I pass matching variables but as soon I put in a code that does not match inside of the table it breaks and gives me an error: 

How do I bring in error handling so that it reports back a message saying the CPT Code was not found in the table. 

I tried playing with conditions and playing with Terminate but I just cant get anything to work.  Thanks for reading.

[Pstork1]

I do this in several of my BOT flows.  Create a string variable to hold the value you want to Return.  Then use a condition at the appropriate point to test whether there is a return value or not.  If Yes, set the variable with that value. If No, set it with *Not Found* or whatever else you want to return.  Then return the contents of the variable.

[VeeLearnMSFT]

Can you please walk me through it. Here is what I have now.  Is this close?

[Pstork1 · Accepted solution]

That's close, but use a single string variable in place of the two compose statements. Just initialize it at the top of the flow and then you can set it either in the Yes or the No side, but it will still be the same variable.  Just different values.  Then return the contents of that variable.

[VeeLearnMSFT]

Sorry I am still having a hard time with this...is there any way you could post a screenshot...sorry just have a long way to go to learn this...

[VeeLearnMSFT]

I recreated the flow...this keeps on happening where I think the flow is not working..I re create the entire thing and it works..there must be some bug within the Teams environment.

[Pstork1 · Accepted solution]

Here's a screenshot of the relevant portion from one of mine.  I'll return the string variable varReturn.