Showing results for 
Search instead for 
Did you mean: 
Post Patron
Post Patron

Why do empty ResultSets continue toproduce error notifications in Console App?

I have still not found a way to eliminate this problem despite asking the same question many times.

This is the annoying message:

The datae returned in the response is invalid.PNG

When I open the App in Edit, there are similar warning signs (red marks showing problems:

Red marks showing problems.PNG

Code window also indicates problems:

Code window showing problems.PNG

But why is it a problem.

The code clearly states If(IsError...


And why is it even an error?


Why is an empty result set an error?


The results from the flow looks like this:


empty results sets.PNG

The actual output form the SQL Stored Procedure looks like this:


So what am I supposed to do?

I have tried using IsBlank or IsEmpty. Neither of those options produces any better results.

Helpful resources

Check this Out


Class of 2020- Season 2

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!


Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,697)