You’re offline. This is a read only version of the page.
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.
@wsalling it was a pleasure, please don't forget to mark the answer as a solution.
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.
Share
Report
All responses (
Answers (
empty(body('Execute_a_SQL_query_(V2)')?['resultsets'])
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
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
