Re: Handling Exception after when an action fails in Flow

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

How do you handle an exception of a request response action failure in flow into powerapps?

@Mr-Dang-MSFT

Categories:

Building Power Apps

All responses (13)

Answers (0)

Sort by

Mr-Dang-MSFT Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous, it looks like Table1 does not exist. The previous step did not output any data which is why Response had an error. You'll need to receive data for this to work. And even if you do not receive data, you still need to have the same JSON structure in your data.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Mr-Dang-MSFTThanks for the reply, I'm sorry for not being too descriptive. Yes I am aware that table1 doesn't exist. Question is how do you catch the error from flow into powerapps by not outputting the json error string into powerapps. more in terms of explicitly displaying a user friendly response back stating for example "you have no records".
Mr-Dang-MSFT Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
@KroonOfficeSol may have an answer here as well.

I check if the results are not empty. I explicitly did this in a compose action, but you can forego it and directly do it in a condition.

I create a condition: if the results are not empty, send the regular response.

Otherwise, do another set of actions. In the example below, I simply used the same response schema, but with a blank body. Feel free to do any other actions of your choice.

In PowerApps, the blank response will result in a default error that says something to the effect that there was no response.

If you want to customize the error to say something different, you can use Notify(). Below I'm using similar logic to the flow, "If the collection is empty, communicate a warning to the user that no records were returned."
KroonOfficeSol 587 on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous

The answer is fairly simple, you just have to insure there is a record returned from your stored procedure. You can do this by adding an UNION ALL SELECT statement to your Select query, returning a row with only NULLS. Null should be matching the columns in the select statement.

Basically Flow gets at least one record and so has the schema and the result to return, so the error won't occur.

Then in PowerApps you remove the last row with this formula.
ClearCollect(YourCollection, YourFlow.Run())
;Remove(YourCollection, Last(YourCollection))
Leaving an empty well structured collection, when you don't have records returned.

Made a video on this topic, see Learn PowerApps | 22 | PowerApps - Flow - SQL Server - import Dynamic Data

Btw: You just have to use three components: PowerApps, SQL, Request.
A nice trick for when the ResultSet.Table1 is not in your dynamic options for the request is to:
go to the custom editor
put in a letter
go back to the dynamic results
Pick the ResultSet
go back and delete the letter
add ?['Table1']

Hope this helps,
Paul
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Mr-Dang-MSFT Thanks, The solution you've proposed works on my local machine but as soon as I publish the app the problem still persists on the published site
KroonOfficeSol 587 on at

Like
a
(0)

Report
Copy link

Link copied!

This is because the clearcollect() gives an error.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Mr-Dang-MSFT Thanks, The solution you've proposed works on my local machine but as soon as I publish the app the problem still persists on the published site
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@KroonOfficeSol Paul, thanks alot for the solution I have implemented what you've said regarding putting ResultSet.Table1 on the second request together. It works on the published site as well now. @Mr-Dang-MSFT
KroonOfficeSol 587 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

Again, lose the condition, this is unnecessary. Only three steps are required, see pic.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@KroonOfficeSol I have to include 2 requests because I'm validating for when a when action fails between the first request.