Hello Community,
My PVA bot is asking user for a number type input from user, then calling a flow to read a spreadsheet with 2 columns:
- Number column with stored numbers.
- Date column with corresponding dates.
The flow is using Excel Online "Get a row" action to match to the 1st column. If value is matched, it is returning the corresponding date value to PVA. All good so far.
Where I'm running in to problem is if the user input is a value that doesn't exist in the 1st column. PVA returns the following error:-
Sorry, the bot can't talk for a while. It's something the bot's owner needs to address. Error code: 2003. Conversation ID: IFGLv8jC2We8EHd4kDwbKV-us. Time (UTC): 12/31/2021 1:21:50 PM.There's a problem with in . Please check your content.
The failed flow run shows error that "No row was found with Id '123456'"
I tried Conditions, but no luck. Then I tried to set variables and scope like this.
The successful path works, but I run in to schema errors as soon as I introduce the unsuccessful path (picture below doesn't work). I can't even save the flow. I also tried just sending value to PVA without the Success/Fail scope, but same error.
Any suggestions how to catch "not found" error and handle it so that I can send a message back to PVA and ask the user to provide a valid entry? Thanks in advance.
