SQL Query from Power Apps using Flow (Tutorial) 

I didn't realize I would find the solution to all of my problems in this video. Watching this in August of 2024 and this method just helped me pull 89k records from SQL during a test. Just with the simple method that you shared, Dawid, it can be utilized into different more ways. THIS IS AMAZING. THANK YOU FOR THIS AMAZING VIDEO! So sad to see that you haven't uploaded recent videos on your channel. :(

Hi Dawid, great demonstration and thank you for sharing. The manner in which you explain the methods is really good. Thank you

This is really great , I was finding the solution actually to capture the data after executing SQL query in Power Automate. Thanks Man 🙂

Fantastic tutorial, I was able to make the app with live data from our ERP system. The onl yproblem is that a non Premium users cannot open th app as it contains premium connectors through the flow. Any idea how to work around this so also PRO users will be able to use this APP? Thanks a lot

Hello David, Do I need a compose if my input is int instead of string. What replace function will I use?

Hi @dave, Thanks for this wonderful video. I am using it on prem where execute SQL query is not supported. Any other workaround in Get rows trigger

Hi Dave, If result of query is empty the powerapps show an error: response data must be a valid Json object. How to evoid this message?

Nice Do you have a video using Stored Procs instead of a sql query?

hello, what if there are zero items as result of the query? how do I avoid the error in powerapps saying that it was expecting a json in return but got nothing?

Dave, this was really good. I'm new to PA, been using Excel tables up to this point. But that 2000 rec limit is choking me. So I will move up the next step to SQL queries. Thanks again.

Omg you saved my life 😆 thanks for this useful video, bless you!!! 🙏

Thank you Dave, fantastic presentation! And usefull. Would you be so kind to help me with a hint for this issue. I understand that Json does not support datetime values, so if i load the response output in a powerapps gallary i get a completely different date. Do i need to convert the Response output? Or do i need to use add collums in the collection to convert the string to datetime? Thankyou for any idea!

Really good explanation. Thanks a mill

Hi Dave, where do you put the schema? I couldn't run a query with Oracle.

The response connector does not appear in power automatic

Do you have any experience with on premise SQL databases using gateways. I can't get flow to link to gateway with 100% success. It's hot or miss

Hi Dawid, is there any video that you covered uploading images in to SQL table means images converting in to binary data please share the link.

If you use the counter query, remember rename the title result that came in blank, wiht (AS "nameyouwant"), if not it doen't work