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

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

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,240)