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

I have the same question (0)

All responses (4)

Answers (1)

manuelstgomes 6,625 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

ChristianAbata 8,951 Most Valuable Professional on at

Like (1)

Report
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'])

Was this reply helpful? Yes No
wsalling 114 on at

Like (0)

Report

Thank you

Was this reply helpful? Yes No
ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

@wsalling it was a pleasure, please don't forget to mark the answer as a solution.

Was this reply helpful? Yes No