Answered

Execute a SQL Query and Catch a Empty Return

(1) Share

Report

Posted on by wsalling

114

i am running a very simple query. Say "Select * from junk" using the Execute a SQL query Action. I if data is in the table everything works fine. My collection is populated in Powerapps. The problem is when the table is empty and returns nothing. I need a way to know in powers that it returned nothing. i need help on catching or responding with text or empty table so i can countrows to determine it is empty to continue with my next step on nothing found with Query.

Please help. Dragging my brain for a day now.

Office 365.

Categories:

General topics

All responses (5)

Answers (1)

Sort by

manuelstgomes 6,643 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @wsalling

I'm not an expert in PowerApps but I think you can try to catch that on the "onVisible" of the page and count if the source has or not values. If not you can do a "Navigate" to the section you want.

But the good folks over at the PowerApps community can probably help you better than me:

https://powerusers.microsoft.com/t5/Power-Apps-Community/ct-p/PowerApps1

Hope this helps you

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel
Verified answer

ChristianAbata 8,953 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @wsalling you can manage empty consults like this.
So the compose gives you a true value, and the if is true you can do somenthing.
empty(body('Execute_a_SQL_query_(V2)')?['resultsets'])
wsalling 114 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you
ChristianAbata 8,953 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@wsalling it was a pleasure, please don't forget to mark the answer as a solution.
Fred3 Xu 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Mates,

I use this fx 'empty(body('Execute_a_SQL_query_(V2)')?['resultsets'])' but still show errors:

How should I adjust and fix it? Do you have any suggestions? thanks.