SQL Query from Power Apps using Flow (Tutorial)

[@jamesnadua2738]

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. :(

[@rayno4494]

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

[@DavesTechTips]

Thank you very much for the feedback Rayno, much appreciated and glad you found it useful

[@muhammadmubashir8060]

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

[@christinjosephdc6094]

Really good explanation. Thanks a mill

[@jankucera1512]

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

[@siddhkishan]

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

[@simrankaur6075]

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

[@AdielCondoriLazo]

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?

[@russellniebolt1493]

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.

[@distribuidormayorista869]

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

[@selwynvanrooyen9432]

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

[@AngeloGuarinojusttowash]

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?

[@callfusion2012]

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!

[@Dee23557]

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

[@cesarsoriano9886]

The response connector does not appear in power automatic

[@kmuralikrishna1582]

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.

[@DavesTechTips]

Hello Kmurali, yes for sure, please see below playlist. Part 5 shows SQL binary data. kzbin.info/aero/PLxhCbU5zMGws9szHptqfV2RzBHtceI07V

[@vozdesilencio]

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

[@DavesTechTips]

Thank you so much Isa, I will check it out ;)

[@akhtarmiah]

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

[@DavesTechTips]

Yes we use it often without a problem. SQL Queries don't work to on premises SQL though, you need to use stored procedures for this. Here is a video that shows this method. kzbin.info/www/bejne/eHKqc61_ad-Xrdk

[@ML_1515]

@@DavesTechTips We are also trying to use this with on-premise server with no luck. Even have an MS ticket but still not resolved. So we have to use stored procedures?