Power Platform Community Forum Thread Details

Hello All,

I know there is a way to do this just cannot figure it out. I have a flow that interacts with an excel sheet on sharepoint. User enteres in inputs, like dates and pay grade and theh bot comes back with an hourly pay rate. If the user creates an entry in which the excel sheet output is an error. I would like the bot to display something like this when it doesnt know what to do or the excel sheet displays an error. "You have made an incorrect entry please review your inputs".

This is what the bot comes back with. The user does not know what to do if they see an error like this.

Categories:

General topics

Hi @VeeLearnMSFT,

You could introduce a variable and use a set variable which only runs when a specific action fails. In your setup that would probably be the run script, correct?

That would be the simple setup. You can also introduce the usage of scope actions and implement a try-catch pattern. There are loads of examples on the internet about these. Do let us know if you need any additional help implementing that.

Below is an example of the configure run after approach.

1. A short demo how you can configure the Set variable - Has failed action to only run if the Run script has failed. When it succeeds it will just skip this action and continue with the Set variable has succeeded action.